Generate SQL Script including actual Data  
Author Message
grecian9





PostPosted: Thu May 05 03:33:56 CDT 2005 Top

SQL Server >> Generate SQL Script including actual Data

Hi NG

Is there a way to generate an SQL Script that not only includes database
structure but also the content / data of tables ?

helps appreciated

Christian

SQL Server41  
 
 
Uri





PostPosted: Thu May 05 03:33:56 CDT 2005 Top

SQL Server >> Generate SQL Script including actual Data Christian
BACKUP\RESTORE commnads




> Hi NG
>
> Is there a way to generate an SQL Script that not only includes database
> structure but also the content / data of tables ?
>
> helps appreciated
>
> Christian
>
>


 
 
Christian





PostPosted: Thu May 05 03:44:55 CDT 2005 Top

SQL Server >> Generate SQL Script including actual Data i can't figure out what you're talking about . could you give me some infos
?

Chris


> Christian
> BACKUP\RESTORE commnads
>
>


>> Hi NG
>>
>> Is there a way to generate an SQL Script that not only includes database
>> structure but also the content / data of tables ?
>>
>> helps appreciated
>>
>> Christian
>>
>>
>
>


 
 
Jens





PostPosted: Thu May 05 03:49:34 CDT 2005 Top

SQL Server >> Generate SQL Script including actual Data Try QALite (Downloadable from the internet), i will provide you with a set
of functions to get additional Insert Statements for the data.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---




> Hi NG
>
> Is there a way to generate an SQL Script that not only includes database
> structure but also the content / data of tables ?
>
> helps appreciated
>
> Christian
>


 
 
Uri





PostPosted: Thu May 05 03:59:17 CDT 2005 Top

SQL Server >> Generate SQL Script including actual Data Sure
---We perfom a backup of the database
BACKUP DATABASE test TO DISK='C:\mydatabase.bak'

----Now we restore the database with a new name
RESTORE DATABASE test_newname
FROM 'C:\mydatabase.bak'
WITH RECOVERY,
MOVE 'test_data' TO 'D:\Test_data.mdf',
MOVE 'test_log' TO 'D:\Test_log.ldf'

For more details please refer to the BOL




> i can't figure out what you're talking about . could you give me some
infos
> ?
>
> Chris


> > Christian
> > BACKUP\RESTORE commnads
> >
> >


> >> Hi NG
> >>
> >> Is there a way to generate an SQL Script that not only includes
database
> >> structure but also the content / data of tables ?
> >>
> >> helps appreciated
> >>
> >> Christian
> >>
> >>
> >
> >
>
>


 
 
Christian





PostPosted: Thu May 05 04:22:26 CDT 2005 Top

SQL Server >> Generate SQL Script including actual Data Ok, downloaded and installed ... but where can i generate an SQL Script ?

My intension / target

i've a database with content. i wan't the whole database structure INCL. the
data i a SQL Script .. i don't wanna backup / restore the database! my
target is to have a SQL-Script!

Christian



> Try QALite (Downloadable from the internet), i will provide you with a set
> of functions to get additional Insert Statements for the data.
>
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
>


>> Hi NG
>>
>> Is there a way to generate an SQL Script that not only includes database
>> structure but also the content / data of tables ?
>>
>> helps appreciated
>>
>> Christian
>>
>
>


 
 
Christian





PostPosted: Thu May 05 04:22:54 CDT 2005 Top

SQL Server >> Generate SQL Script including actual Data My intension / target

i've a database with content. i wan't the whole database structure INCL. the
data i a SQL Script .. i don't wanna backup / restore the database! my
target is to have a SQL-Script!

Christian


> Sure
> ---We perfom a backup of the database
> BACKUP DATABASE test TO DISK='C:\mydatabase.bak'
>
> ----Now we restore the database with a new name
> RESTORE DATABASE test_newname
> FROM 'C:\mydatabase.bak'
> WITH RECOVERY,
> MOVE 'test_data' TO 'D:\Test_data.mdf',
> MOVE 'test_log' TO 'D:\Test_log.ldf'
>
> For more details please refer to the BOL
>
>


>> i can't figure out what you're talking about . could you give me some
> infos
>> ?
>>
>> Chris


>> > Christian
>> > BACKUP\RESTORE commnads
>> >
>> >


>> >> Hi NG
>> >>
>> >> Is there a way to generate an SQL Script that not only includes
> database
>> >> structure but also the content / data of tables ?
>> >>
>> >> helps appreciated
>> >>
>> >> Christian
>> >>
>> >>
>> >
>> >
>>
>>
>
>


 
 
Jens





PostPosted: Thu May 05 04:54:57 CDT 2005 Top

SQL Server >> Generate SQL Script including actual Data DOn´t know how many tables you´ve got... but there is a qay to script a
single table in QA, right click on the Table --> DDL and inserts.

Jens SUessmeyer.



> Ok, downloaded and installed ... but where can i generate an SQL Script ?
>
> My intension / target
>
> i've a database with content. i wan't the whole database structure INCL.
> the data i a SQL Script .. i don't wanna backup / restore the database! my
> target is to have a SQL-Script!
>
> Christian
>


>> Try QALite (Downloadable from the internet), i will provide you with a
>> set of functions to get additional Insert Statements for the data.
>>
>> HTH, Jens Suessmeyer.
>>
>> ---
>> http://www.sqlserver2005.de
>> ---
>>
>>


>>> Hi NG
>>>
>>> Is there a way to generate an SQL Script that not only includes database
>>> structure but also the content / data of tables ?
>>>
>>> helps appreciated
>>>
>>> Christian
>>>
>>
>>
>
>


 
 
markbaekdal





PostPosted: Thu May 05 05:20:03 CDT 2005 Top

SQL Server >> Generate SQL Script including actual Data try the free data and schema scripter from Innovartis. It comes free with the
evaluation of DB Ghost -
http://www.innovartis.co.uk/database_change_management_evaluation.aspx


regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server






> Hi NG
>
> Is there a way to generate an SQL Script that not only includes database
> structure but also the content / data of tables ?
>
> helps appreciated
>
> Christian
>
>
>