I'm working on creating a test database on our server which will have the same column names as a current database.
Our programmer wants this test database to work on some issues with our programs and SQL Server performance issues between two diffrent domain.
What I want to do is copy all tables from one database into the new test database but without the data; just the column names.
can i do this with DTS or is there another way of performing this task. When i imported the tables from one database into the test all the data came over of course. I did not see an option to not include the data unless I'm over looking something.
start -- run type "dtswiz" enter
select your source db
select you destination db
check "copy objects and data between sql server databases
clear the copy data check box
clear the copy all objects check box
click select objects and choose the objects you want
continue with the dts import export wizard and create a package that you can reuse.
the you can use it as a prototype and modify it to suit your exact needs.