Schema Compare API
The ability to compare two database schemas is not new to the database market. One is built into Visual Studio
2010 if you buy the Ultimate Edition. You cannot use the API on a non developer
machine, nor can you ship an executable to end users for their use.
Most schema compare tools offer the ability to visualize the differences between two database schemas,
then generate a sql script to execute the changes. These change
scripts often contain logic errors for things like column renaming (most drop
the old columna and add a new column with the new name - losing your old data).
Developers and DBA’s often find it more useful to simply visualize the schema differences and execute changes
with custom scripts. The Schema Compare tool was designed to
give you API access to the differences between database schemas, even across
database
vendors.
API Access to Schema Compare
Our Schema Compare Tool allows for API access to comparison of databases from
multiple vendors. The changes are returned through a collection of schema
objects that can be used by your application to determine what to do with those
changes.
Databases Supported
- Microsoft SQL Server 2005/2008/2008R2
- Microsoft SQL CE 3.5
- VistaDB 4
- MySql 5
We Need Your Feedback
This product is still under development, and we are seeking feedback from developers on what features and functionality they would like to see in the product.
Each user who submits feedback for us will be entered to win a free copy of the final shipping tool, and be invited to participate in the beta.
Submit Product Feedback
Signup for a trial
Would you like to try one of our database tools? Visit the
trial signup page for complete information.