I have a set of databases each with a table with one-to-many relationships to two other tables.
I want to merge the tables from one database into another, but the primary keys start at 1 for each database - and so the keys conflict when merged into one unified table.
Is there any way I can...