copy sql server database (structure only)...

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

copy sql server database (structure only)...

Post 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.
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

For what type of sql server?
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

mssql 2000
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

DTS (Data Transformation Services) in Enterprise Manager.
Post Reply