SQL Server Performance Forum – Threads Archive

Creating Table structures without populating

I want to copy some AS/400 DB2 tables to my SQL Server 2000 database. I don’t want to copy the data, just import the structures. Is this possible with DTS? I did import a table into the SQL Server, but it pulls the data too! I don’t see an option to only create the table. I was able to modify the original package and force the select statement in the transform step to return no rows, but there are hundreds of tables and I don’t want to go into Transform property to change the Select statement for every table. Am I missing something really obvious? Any ideas? Thanks! Kevin

I don’t know about DB2, but see whether its possible to script the tables in Db2. If so try to apply the script after modifying as per SQL server requirement. Another option is to dump data to temp. tables and generate script and use the script file as a source and use whenever require to create the tables. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Actually, that was my next step…I was going to use AllFusion ERWIN to reverse engineer the data structures and create a script to recreate on the SQL Server. At least I can then modify the SQL in one file and gen the tables. Thanks for your response! Kevin (out…)

I don’t see any other workaround, as of now. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>