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.

Thanks

The SQL Rookie

How big is the database?

I'd dump and restore.....

Brett, he/she wants just the structure, not the data.

You can just script the schema from EM and paste it in QA.

If the database is no big you can use DTS to copy tables and next use truncate table

Using DTS is over kill. Right click on the db in the Enterprise Manager -> All Tasks -> Generate SQL Script...

Pick what you want included in your test version of the database....

Use the DTS Import\Export Wizard

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.

Scott does DTS...

I really dig dts.
as a matter of fact rdjabarov i'm teaching a 5 day dts class in about 2 weeks
you could show up and net send everyone into a stupor.

Hee Hee