Why not just backup the db or use DTS to transfer the tables and data? > -----Original Message----- > From: Vance M. Duke [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 12, 2006 11:33 AM > To: CF-Talk > Subject: RE: Scripting DB records in enterprise manager > > 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:229348 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
