var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Duplicating a Database
What i am trying to do is duplicate a database on my server without the data contained within it. Is there a way to do this and if so, how?
Script out the entire database, except the database creation part (just tables, views, procs, functions, whatnot), then execute it against your new blank database.
Do you know what Enterprise Manager is?
Yeah, can i do this in enterprise manager?
Go to the database you want, right click on the database
In the menu items look for AllTasks>Generate SQL Scripts
There are 3 tabs, make sure you select ALL of the appropriate options
Then script to 1 File.
Save the file (I would use Windows ANSI Text option)
Then run the script in QA
Thank you both for your help
Did it work?
...or through the Data Transformation utility within EM, just copy the objects and not the data.
again with the DTS thingy??????
You REALLY hate DTS, don't you?
Its a pretty convenient way for ad-hoc data transfers and copying schemas. I just think that the implementation of the packages is clunky. It's too much of a hodge-podge of different technologies for my taste, and thus violates the KISS principle.
But from the ER menu system copying databases through DTS is just point-and-click...so I use it frequently.
I'm thinking about creating a database application that uses dynamic SQL to call DTS packages that import GUIDs.
Just to drive you crazy.
Yo blind dude !!!
Just go ahead with it ... do send a copy of the script to me too ...
Anyone has any idea how to go on implementing Type 1 ETL logic using DTS Package ... the source tables cannot be modified (i mean cannot create triggers or anything on the source tables)
Get yourself a copy of the
The Holy Book
order has no physical Brett in The meaning of a Kaiser . -database data
Logic in a DTS package?
Not something I would do...
Load it all into staging tables and let TSQL handle it from there. That's my standard method.