Matt, Thank you for your solution, it worked perfectly!
Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Matthew Fusfield" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 10:35 AM Subject: RE: OT Generating a data/Enterprise Manager > 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
