SQL Server Performance Forum – Threads Archive
How can I create a blank database from an existingHow 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. —
Microsoft SQL Server MVP
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.