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.