Suppose I have two distinct databases with identical schemas but different data. I want to merge the data between the two databases by adding the data from one into the other. Foreign key relationships, etc. need to be maintained when the data is migrated.
Are there any tools (or databases that have built-in tools) to make this job fairly simple?
This functionality is built into Windows Team System (the database edition or the suite). I have tried both this and an older version of Red Gate's SQL compare and both are awesome to work with. There are also some free tools (see this thread) but I do not have experience with any of them
Visual Studio Team/Database versions have schema/data comparison tool.
Hi, the tools I like :
Nob Hill Database compare if you want entire tables. Columbo if you want more specific data. (Columbo is still free for feedback)