Redgate Sql Compare Alternatives
It does not, but there is an alternative to Redgate that can be used to compare PostgreSQL. No Menu IT Support Forum. A community of IT professionals. No Menu Redgate Alternative For PostgreSQL. Posted on by Webmaster. ApexSQL Developer tools vs. Alternatives comparison This blog post represents an index of pages and articles comparing ApexSQL tools for SQL Server Database Developers, their features, usability, performance, etc. With related tools developed by other vendors and in general.
Any decent alternatives to Red-Gate DLM?
We are working on a project to have one centralized MS SQL database that we keep up to date, and roll out those schemas to new QA servers, or update the existing QA server with schema changes. Red-Gate DLM was perfect for this, I loved it and sold my company on buying and using it.
That's when the sales call happened and they explained their licensing model. Even though everything will be orchestrated and rolled out from one central build server, ANYONE who touches the master database, anyone who benefits from the automation, also has to buy a $3,000 license. So now we've gone from buying 2 maybe 3 licenses, along with our business partners buying licenses, to having to buy 30-40 licenses. Red-Gate says there is no wiggle room there and is the most absurd thing I've ever heard. What are you guys using for something like this? We also have licenses for the data generation tool they have that we were going to buy more of, but are now looking to move away from their products all together.
Thanks!
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.
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
Redgate Sql Compare Alternatives
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.