Data migration problems

  • Thread starter Thread starter ben
  • Start date Start date
B

ben

I want to migrate records from some old DB's into a newly
designed DB. I read one of the posts below dealing with
this topic, and i think i can get through that part, but
the problem i see coming is the primary keys (ShaftID#)on
the two old tables have identical values to those on each
other table.
Is there a way to change the value (of the old ID#'s) a
little bit automatically, or should i just manually add a
number or two to the old ID's? (There are a total of
about 2200 records, so an automated way of doing it would
save me a lot of grunt work)
 
Back
Top