Generate Table Script

[Giddygoat]

In Enterprise Manager I can create a SQL scripted version of my schema. I.e. the script will generate CREATE TABLE and constraints, indexes etc. What I'd like to do is create the schema along with its data.

INSERT INTO myTable ......

for all of the data in the schema.

Any ideas?

 

[dbomrrsm]

can I suggest you look at DTS to do this sort of data transfer.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[Giddygoat]

I need to generate insert statements.

I've found tools to do it for Oracle and My SQL but not SQL Server