I have two databases with the exactly same structure (schema). The structure includes foreign key constraint and identity columns. One database contains heavy data and the other contains light data. I want to combine the two separate databases into one database. What would be a better way to do it? How should I write script to do it?
Actually I'm thinking about how I should handle the identity columns and keep the relationships.