Compare Snapshot to Database

wkhazzardwkhazzard Posts: 20
edited March 23, 2011 4:11PM in SQL Comparison SDK Previous Versions
I am trying to compare a snapshot to a database using the SQL Compare SDK. I have looked at all the samples and combed through the object model. I can't figure out how to get a SnapshotSource object to behave as a Database object or vice versa. Nor can I find a CompareWith method on the database class that accepts a SnapshotSource or an IDataSource. Is there a sample floating about at Red Gate that shows how to compare a snapshot with a database in the same way that the stand-alone SQL Compare tool does this?

Thanks,
Kevin Hazzard, C# MVP & Friend of Red Gate
http://devjourney.com
· Share on Twitter

Comments

  • James BJames B Posts: 1,124 Silver 4
    Thanks for your post. I think the snapshotsource is more for creating the snapshots.

    If you set it up to work with two Database objects, you should be able to use the "LoadFromDisk" method on one of them to load a snapshot file, i.e:
    Database productionDB = new Database();
productionDB.LoadFromDisk(@"c:\snapshots\MySnapshot.snp");
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
  • wkhazzardwkhazzard Posts: 20
    Thanks, James. Worked like a charm. The LoadFromDisk method name just didn't jump out as the correct way to load a snapshot.

    Cheers,
    Kevin Hazzard, C# MVP & Friend of Red Gate
    http://devjourney.com
    · Share on Twitter
  • James BJames B Posts: 1,124 Silver 4
    No, it took me a little while to find that one too! Glad it's working.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.