There is also a stored procedure that was written and I have used extensively if you do not want to pay for Red-Gate.
http://vyaskn.tripod.com/code/generate_inserts.txt This will script the inserts and will also set the identity Off and then Back on... You can take all these insert statements and paste them at the end of you CREATE tables and keys statements. Vance -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 8:58 AM To: CF-Talk Subject: Re: Scripting DB records in enterprise manager Mike, If this is something that you need to do often, or need to keep those two databases in synch, I would definitely check out the sql-compare and sql-datacompare tools from redgate... http://www.red-gate.com/ They are a bit pricey, but they can save you a lot of time and headache. -jim On 1/11/06, Mike | NZSolutions Ltd <[EMAIL PROTECTED]> wrote: > hi guys, > > I need to duplicate some existing tables to a new SQL database. > > i am trying to script my sql server db, and include all records - not > just the table structure. i am using the generate SQL script tool, but > cannot seem to include the records. > > does anyone know what i am not doing? > > Regards > Mike > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229345 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
