all groups > sql server misc > june 2006 >
You're in the

sql server misc

group:

Copy database structure only



Copy database structure only Neil
6/30/2006 5:17:40 PM
sql server misc: Is there a way to copy a database structure only without all the data?

Thanks.

Re: Copy database structure only mindless fka ZJ
7/3/2006 8:18:02 AM
[quoted text, click to view]
in Enterprise manager (EM) do this:
- right click on the database, all tasks, generate sql script
- carefully choose all indexes, keys, ... all that you want to script
- save the script file

Now, open Query Analyzer (QA) and connect to server where you created
new database (empty), open the script file and run it

voila,

AddThis Social Bookmark Button