I have a client who is thinking of combining two separate databases into one larger one. The schema are identical so it's just a case of making sure of pulling the data in so that new keys are generated and the data sits side by side with the other.
Is is just a question of using a migration tool like Redgate to migrate the data, or do I have to write a series of scripts to insert all the data from db1 into db2? The main issue is that the schema is quite complicated.
Just looking for advice at this point.