Duplicate a database
-
I want to make a copy of my sql server 2000 database. I want all the tables, relationships, stored procedures, diagrams etc but none of the data . How can this be accomplished ? Try not! Do or do not, there is no try. - Master Yoda
-
I want to make a copy of my sql server 2000 database. I want all the tables, relationships, stored procedures, diagrams etc but none of the data . How can this be accomplished ? Try not! Do or do not, there is no try. - Master Yoda
Script the database.... Open Enterprise manager, and navigate to the database in question. Right-click, all tasks, Generate SQL Script. In the new dlg, click Show All, and select0 Script All Objects. Click OK and tell it where to save it. This will generate a .sql file that can be run through Query Analyser / OSQL etc. that will create all entities in your database.. "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox
-
Script the database.... Open Enterprise manager, and navigate to the database in question. Right-click, all tasks, Generate SQL Script. In the new dlg, click Show All, and select0 Script All Objects. Click OK and tell it where to save it. This will generate a .sql file that can be run through Query Analyser / OSQL etc. that will create all entities in your database.. "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox
Cool trick, tried on Northwind and the 11,000 lines plus of sql generated a slew of 'Invalid object name' errors. Probably just needs more investigation on my part though :-O Thank you. Try not! Do or do not, there is no try. - Master Yoda
-
Cool trick, tried on Northwind and the 11,000 lines plus of sql generated a slew of 'Invalid object name' errors. Probably just needs more investigation on my part though :-O Thank you. Try not! Do or do not, there is no try. - Master Yoda
May possibly be because you (I assume) tried to restore it to the existing Northwind DB - the invalid object name ocurrs since you're trying to create duplicate objects IN_THE_SAME_DATABASE.... Again, from EM, navigate to the Databases node, right click, New Database. Configure the new DB, and in QA, select the name of the new DB in the drop down, or issue a "Use " as the first cmd. Then run the script, and should be OK... "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox
-
May possibly be because you (I assume) tried to restore it to the existing Northwind DB - the invalid object name ocurrs since you're trying to create duplicate objects IN_THE_SAME_DATABASE.... Again, from EM, navigate to the Databases node, right click, New Database. Configure the new DB, and in QA, select the name of the new DB in the drop down, or issue a "Use " as the first cmd. Then run the script, and should be OK... "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox
You could possibly be right, I did create a new database and ran the script on it but I may have run the script twice. In any case it did work and all the tables are present and correct. Thanks for your help :-D Try not! Do or do not, there is no try. - Master Yoda
-
I want to make a copy of my sql server 2000 database. I want all the tables, relationships, stored procedures, diagrams etc but none of the data . How can this be accomplished ? Try not! Do or do not, there is no try. - Master Yoda