We have a data set that is updated for each release of our software projects. We need to modify data between releases of software. We are at a point where we need to make changes to data for a future release, but have not finished a current release, and we do not want to affect the data for the current release. We are looking at creating a copy of the database to add the new data. Our problem is we need to continue to add data to our previous database, and bring this data forward. We also may be making Schema changes to the new database that are not part of the previous database.
This seems like an issue that others would have solved, but I am not able to find a solution. We have investigated SQL Replication, but that looks like our Schema needs to stay the same across databases so that won't work for us.
asked Feb 22 '10 at 03:54 PM in Default
Each of those tools will allow you to do filtering in different ways, but you should be able to come up with enough to meet your requirements...
answered Feb 22 '10 at 04:29 PM
Matt Whitfield ♦♦
RedGate works well with Data Compare and SQL Compare. They have very intuitive UIs that will help you with your comparison.
If you would rather use free intrinsic tools - TABLEDIFF, as noted, is delivered with SQL Server 2005 - and it is command-line based.
I have used each of these tools and they all do exactly as intended.
answered Feb 22 '10 at 06:51 PM