Alternatives to Red Gate SQL Comparison SDK?

I've been using the Red Gate S开发者_如何学GoQL Comparison API in a project that's getting long in the tooth. We use a fraction of its abilities and I am evaluating other options.

Our scenario is basically this:

• We have two SQL Server 2008 databases that can be assumed to have identical schemas.
• The databases are tiny. Most tables have less than 10K rows; some have less than 100.
• DB1 can be considered "primary." We only make changes to DB1 directly, and those changes are propagated to DB2.
  • A small set of five tables, when modified in DB1, must be replicated to DB2 immediately.
  • Occasionally the entire database — less a set of exclusion tables (e.g. logs) — must be replicated at once, again from DB1 to DB2. This is triggered from a web form.

At the moment all of this is handled in code using Red Gate's SDK to do the dirty work.

How else might I go about this? I'm open to pure SQL Server solutions (replication?) if you think it's the right choice, though a pure C# solution would require a bit less interaction with my IT department, if you catch my drift.

The only other programmability product I know of would be ApexSQL's Diff API - Apex SQL Diff is a similar product, and they also publish an API to do these things programmatically in your own app.

I've never used it myself, but I have used (and really enjoyed) other ApexSQL tool - highly recommended.

I know I am a bit late to the party, but I've just released the source code to Atlantis.SchemaEngine - which does the schema part of the DB, and was considering whether to release Atlantis.DataEngine (no prizes for guessing what that does). Is that something that would be of interest? SchemaEngine is here.

You could try using FluentMigrator. It's a database migration library for .NET. You could use it to define your schema in C# and then push changes out to both databases.