Database Scripting
-
Hi all,
I am using SQL Server 2005 CTP which has Adventureworks as sample database. I need to generate a script for the database (structure and data) so that I can save it in a .sql file and generate it whenever I need to. I basically need it for my testing, where I need to create or drop the database n number of times.
The Script database available within Yukon is only scripting the database structure. I need structure and data for all the objects within the database.
Any ideas ?
--Kishore.
-
Why not just take a backup of the database?
--------------------
Colt 45 - the original point and click interface
-
Well, that is my last resort. But actually I need a sql script which will contain all the structure and data for the database. Any further ideas ?
--Kishore
-
Why do you need a seperate script that will contain everything that a backup will contain anyway?
--------------------
Colt 45 - the original point and click interface
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply