so if I had 3 related tables the tool would need to extract something like:
insert into table1 (field1, field2) values (1, 'blah'); insert into table1 (field1, field2) values (2, 'blah'); insert into table2 (field1, field2, field3) values (1, 1); insert into table2 (field1, field2, field3) values (2, 2); insert into table2 (field1, field2, field3) values (3, 2); insert into table3 (field1, field2) values (1, 'blah'); insert into table3 (field1, field2) values (2, 'blah'); -----Original Message----- From: Spike [mailto:[EMAIL PROTECTED]] Sent: 19 September 2002 10:40 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (slightly OT) extracting SQL data as INSERT script 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] -- ** 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]
