How can I create a blank database from an existing | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How can I create a blank database from an existing

How can I create a blank database from an existing database with data. I tried to use generate scripts from enterprise manager but it is missing some properties like NO CHECK CONTSTAINT , PRIMARY KEY ETC I got SQLSERVER2000 with sP3
See if this helps:http://www.karaszi.com/SQLServer/info_generate_script.asp If you’re doing this with EM, make sure you check ALL relevant options for you on the different tabs. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
Scripting is the best way of doing this. in th eoption button you need to select the nessesary options to generate all the scripts http://www.geocities.com/dineshasanka/optiontab.bmp
You can use DTS to transfer/Copy the objects with / without data like tables, Sps, views etc. Use DTS import/export and then uncheck copy data option and copy all objects option and then select whichever objects you want to transfer.
Scripting is the best way to go rather than using DTS, that gives flexibility to alert the code if necessary and manage with a version control. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>