March 3, 2009 at 8:54 am
what is the fastest and best way to create an empty database from the existing one. I want use it lie a prototy for creating databases.
March 3, 2009 at 9:00 am
Mike Levan (3/3/2009)
what is the fastest and best way to create an empty database from the existing one. I want use it lie a prototy for creating databases.
Can you provide a little more detail as to what you are trying to accomplish? Do you want all the tables in the database or just an empty shell databae?
March 3, 2009 at 9:10 am
I need an empty shell of the existing database with all the tables empty.
March 3, 2009 at 9:12 am
Using SSMS, right click on the database you are going to use as a template, click Tasks, Generate Scripts, and use the the Script Wizard to generate everything you need.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply