Home Forums Programming General Can you compare an older SQL Server Snapshot to a newer one and recreate any changes made? RE: Can you compare an older SQL Server Snapshot to a newer one and recreate any changes made?<!-- 864 -->

  • A snapshot is like another database, but it doesn't allow you to backup/restore.

    As Jack mentioned, a backup is probably a better choice for bringing things up to date. Otherwise you are really doing a database comparison and trying to move objects and data over, which can be tricky.

    I work for Red Gate Software, and you could use our SQL Compare/Data Compare to do this, but if the databases are large, it might not work well for data.