March 25, 2003 at 11:17 am
Greetings,
I'm a newbie to SQL Server and scripting so please bear with me as I try to explain this...
I've built a database for an application I'm trying to sell. I've been able to generate scripts that will automatically build the DB and tables, but what I want to do is build a script that populate those tables with some generic data.
I have a script that can do this, but I have to update it manually eveytime I add data or change tables, etc., which is extermely tedious. I was wondering if there is an option in SQL Server or a tool out there that I can run against my DB that will automatically export all tables AND data in script format.
Hope I explained this in a way that's understandable to the experts.
Thanks!
March 25, 2003 at 11:30 am
I believe that MS SQL Exec will create script create and insert queries based on your data. Its a freebee here at http://www.sqlservercentral.com/products/#freeware Under tools and generate SQL script you should see the options to script whatever you want.
March 25, 2003 at 11:39 am
I highly recommend this product SQL Compare from red-gate. Read a review from Andy Warren here : http://www.sqlservercentral.com/columnists/awarren/reviewofsqlcomparisonandsynchronizationtoolkit.asp His review is a coupld versions behind, but it has only gotten better.
Tim C.
//Will write code for food
Tim C //Will code for food
March 25, 2003 at 12:16 pm
That SQLExecMS worked great!
Thanks to all for the quick replies!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply