Paul, Take a look at this sp - we've used it numerous times to do exactly what you've described:
http://www.swynk.com/downloads/sp_generate_insert_script.sql Matt -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 11:18 AM To: CF-Talk Subject: Re: OT Generating a data/Enterprise Manager No, I can export the 'data' but not the actual SQL inserts and data combined . at least I can't find how to do it .... I want to include some of this information into an install script that has a number of default values (too many to type in if it can be avoided). Thank You Paul Giesenhagen ----- Original Message ----- From: "Bartee Lamar" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 5:01 AM Subject: RE: OT Generating a data/Enterprise Manager > Would DTS Work for you. > > Bartee Lamar > www.enterpriseenergy.com > MSN [EMAIL PROTECTED] > > > > -----Original Message----- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 20, 2002 1:16 AM > To: CF-Talk > Subject: OT Generating a data/Enterprise Manager > > > Hey Folks! > > I am wanting to export a table and all the data in it into a SQL script > that can be ran to import the data into another database. > > I can script the table creation, and dump the data to a file, but how > can I combine the two together so I can run a 'script' and have it > create the table and import the values at the same time? Is it > possible? > > Thanks > Paul Giesenhagen > QuillDesign > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists