SQL Compare Sample

brij_singh555

I see there is sample in .net for SQL Compare which compares database to database and also script to database.
is there any sample where we can compare snapshot to database?

Tugberk

Hi @brij_singh555,

You should be able to load a SQL Compare snapshot into a C# Database object like below and the rest should be the same as comparing database to database really.

using (Database snapshot = new Database())
{
    // Load the database schema previously stored as the snapshot 
    var snapshotFile = Path.Combine(Directory.GetCurrentDirectory(), "mysnapshot.snp");
    snapshot.LoadFromDisk(snapshotFile);
}

Hope this answers your question but do let us know if you have more questions

brij_singh555

Thank you Tugberk!! that's what i was looking for