Redgate Sql Compare Alternatives
I've been using the Red Gate SQL 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.
The goal of /r/SQL is to provide a place for interesting and informative SQL content and discussions. Filter Posts. When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so: [MySQL] [Oracle] [MS SQL] [PostgreSQL] etc.
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.
3 Answers
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. Download delphi.
I've never used it myself, but I have used (and really enjoyed) other ApexSQL tool - highly recommended. Daniel craig next bond movie.
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.