Page 1 of 1

copy sql server database (structure only)...

Posted: Tue Dec 19, 2006 9:49 am
by Burrito
from one server to another. I need to move the structure of a db I've built from a dev machine to a production machine. There are some nifty wizards for exporting data and backing up the database, but I can't see anything (albeit after only 38 seconds of looking) that does a structure copy or export.

Posted: Tue Dec 19, 2006 9:52 am
by volka
For what type of sql server?

Posted: Tue Dec 19, 2006 9:54 am
by Burrito
mssql 2000

Posted: Tue Dec 19, 2006 2:08 pm
by RobertGonzalez
DTS (Data Transformation Services) in Enterprise Manager.