Copying data from a tbl to slightly different tbl

• Ricky Harlow

  Newbie

  Points: 1

  More actions

  October 8, 2002 at 3:43 pm

  #79634

  We are going to be upgrading to a new database structure. There will be some new tables. The existing tables will only have new columns. No columns will be removed.

  Is there a fast way to copy out all the data from every existing table and then import it back into a table with the same name. Again the fields will not match one for one.

  Start with tblTest

  Column1 Column2

  New tblTest is

  Column1 Column3 Column2

  I am tring to avoid the brute force method of walking the tables and building INSERT INTO [tblTest]([Column1 ], [Column2]) VALUES ('dataColumn1 ','dataColumn2)

  for every row.

  Thanks for your help.

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  October 8, 2002 at 4:07 pm

  #438100

  You could of course use INSERT INTO newdb..tbl (col1, col2) SELECT col1, col2 FROM olddb..tbl

  Or just use the Import/Export Tool, should be pretty handy in this case.

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/