Any good SQL Anywhere database schema comparison tools?

Question

Are there any good database schema comparison tools out there that support Sybase SQL Anywhere version 10? I've seen a litany of them for SQL Server, a few for MySQL and Oracle, but nothing that supports SQL Anywhere correctly.

I tried using DB Solo, but it turned all my non-unique indexes into unique ones, and I didn't see any options to change that.

Answer 1

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

Answer 2

If you are willing to download SQL Anywhere Version 11, and Compare It!, check out the comparison technique shown here:

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

You don't have to upgrade your SQL Anywhere Version 10 database.

Answer 3

Two I've come across that support SQL Anywhere:

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

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

Each one appears has a schema comparison tool, however I have not used either to compare schemas.