Right, But in what format is the original data?
Are the original database tables in the same format? If not, what is the original format? I still don't really see the point of what you're doing though... Can you explain a little more? Spike > -----Original Message----- > From: Peter Harrison [mailto:[EMAIL PROTECTED]] > Sent: 19 September 2002 12:54 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] (slightly OT) extracting SQL data as > INSERT script > > > 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] > > -- ** 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]
