I'm not sure exactly what you mean here... Do you want to export the database to somewhere else?
If so, you can use data transformation services to create the export script. You can then either manually run the data transformation services package, or call it programmatically. Spike > -----Original Message----- > From: Peter Harrison [mailto:[EMAIL PROTECTED]] > Sent: 19 September 2002 11:25 > To: Dev@Lists. Cfdeveloper. Co. Uk > Subject: [ cf-dev ] (slightly OT) extracting SQL data as INSERT script > > > Hi all > > Anyone know how I can extract all the DATA from my SQL Server > 2000 user tables as one big SQL "INSERT" script? > > Bear in mind tables are related to eachother, etc. Saving the > database structure as a script is no problem, as is exporting > single tables. This is not what I am after. > > Is there a piece of software that can do what I need? > > Thanks. > > - Peter H. > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
