Any good SQL Anywhere database schema comparison tools?

Question

Are there any good database schema comparison tools that support Sybase SQL Anywhere version 10? I saw a lot of them for SQL Server, several for MySQL and Oracle, but nothing supports SQL Anywhere correctly.

I tried using DB Solo, but it turned all of my unique indexes into unique ones, and I did not see any parameters to change this.

Answer 1

If you want to download SQL Anywhere Version 11 and Compare It !, check out the comparison method here:

http://sqlanywhere.blogspot.com/2008/08/comparing-database-schemas.html

You do not need to update the SQL Anywhere Version 10 database.

Answer 2

The new guy on the Qwerybuilder block. It supports SQL Server, Sybase ASE, Sybase SQL Anywhere, and Oracle. I have successfully used it with SQL Anywhere to track schema changes.

Answer 3

Two I came across SQL Anywhere support:

Upscene Database Tool Database - http://www.upscene.com/products.dbw.sqlanywhere.php

Aquafold - http://www.aquafold.com/index-sybaseany.html

Each of them has a circuit comparison tool, but I have not used it to compare circuits.

Answer 4

SQLDelta is awesome. This is for SQL Server. I used it with SQL 2000 and 2005. It will compare stored procedures, tables, views, permissions, indexes, etc. It can also compare data between tables that I think. You can synchronize changes or generate SQL scripts for later use. I often use it to script out db changes in development to production.

Ah ... missed Sybase's comment. Not sure if SQLDelta can talk to him ... but I would probably give him a chance, since Sybase is similar.

Answer 5

Try erwin (CA AllFusion ERwin Data Modeler). It supports quite a few different databases, including SQL Anywhere, and is not bad for designing feedback / feedback schemes / schemas. However, you may find that it is too difficult to use for comparison ...

Answer 6

I use SQL Data Compare from Red Gate with SQL Compare data comparison allows you to compare the contents of two databases and automatically synchronize data. SQL comparison allows you to do the same, but with database tables. Good GUI on every and very simple setup. they also work with a remote database.

It’s not cheap there, but each of them has 30 paths so that you can feel whether you like it or not.

Answer 7

Sybase PowerDesigner can also compare or combine database schemas.

It can also load a schema from different ODBC databases, if you have schema generation scripts, you can also load them into a model.

Its an expensive tool, but great for documenting and developing IMHO schema changes.

Answer 8

Breck Carter's idea is a good one. For a quick scan, I have an old product called DBDelta. I installed it on an old Windows 2000 machine, because the installation I installed will not work on a computer with XP. This is a very small application that compares two SQL Anywhere databases through an ODBC connection.

I performed some searches to try to find a later copy, but could not. The developer was Charles Butcher. I think he supported him for a while, and then stopped in 2002 or so.

I will continue to search for the link. If I find something, I will post it here.

Answer 9

QweryBuilder 5.5.0 allows you to compare all procedures, functions, views, tables and triggers in one shot. This release is scheduled for mid-May 2010.

It is not complete yet, but we are also considering adding an option to convert the diff results to a script that can be executed in the target database.