Generate SQL Script 2

[Adhie]

Hi,

I need to generate sql script including Data Definition Language (DDL) and the data it self on SQL Server.

Any advice, welcomed.
Thank you very much.
Martin

 

[ClaireHCM]

Generate script for data? not that I am aware of.

Definately you could generate script for those DDL.
Right click on Database name, select All Task, select Generate SQL Script , After that define the scripts which you want to create (Pretty descriptive, if you still have problem, let me know)

I may be wrong.Does anybody know how to generate script for data in a table?

 

[nigelrivett]

ddl you can use dmo or enterprise manager (which uses dmo)
see

http://www.nigelrivett.net/DMOScripting.html

http://www.nigelrivett.net/DMOScriptAllDatabases.html

for the data you can use bcp to create text files or create insert staements
see

http://www.nigelrivett.net/sp_CreateDataLoadScript.html

You will have problems about the ordering of operations if you have foreign keys.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[nphani]

Hi Friends,
I have a similar question as Adhie and nigelrivett seems to say that Generating table Data with SQL Scripts is possible. I am using SQL Enterprise Manager version 8.0 and donot see any option of including data in the generated script. Can someone help me with this.
Thanx in advance,
Phani

 

[nigelrivett]

The link I have given above is an SP to create insert statements.
It is quicker to use bcp though.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.