Importing data into a new db structure

• Laurie-209395

  Newbie

  Points: 2

  More actions

  February 16, 2005 at 11:12 am

  #87716

  We are re-developing an application that requires redesign of an existing db structure, and ultimately some of the data in the existing db is going to be represented in a different format.

  for example: a column in a user table has a list of job targets for that user. in the new structure there is a table which lists a standard list of job targets which will be represented in the new user table as the ID of that particular Job Target, instead of the name of it.

  So my question is this - is there a script that I can write during the import that will look at the values of the Jobtargets column in the old user table, check for its ID reference in the new JobTargets table, and then replace those values into the respective jobTarget column in the new user table?

• wz700

  SSCertifiable

  Points: 7133

  More actions

  February 21, 2005 at 9:34 pm

  #543400

  Assume data types are the same

  Update a

   set jobtargets = b.id

  from old_jobtargets a

   inner join new_jobtargets b on a.jobtargets = b.jobtargets