Data migration problems

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top