Recommendations on a sql comparison (schema & data) tool that supports both Oracle and SQL Server?

Question

I'm trying to find a good tool (open source or commercial) for doing comparisons of database instances, for example:

1. Compare 2 database schemas; generate platform specific change script (either direction) to bring one into synch with the other
2. Compare data (table contents), generate platform specific change script (either direction) to bring one into synch with the other
3. Migrate an entire database schema + data from one platform to another, ie: port an Oracle database to SQL Server (hopefully including support for sequences and identity columns)

For 1 & 2 above, by platform specific I mean the script native to the specific database platform, not, for example, an ODBC equivalent script.

Personally, I am mainly concerned with SQL Server and Oracle support, but MySQL support would be very nice to have as well.

Answer 1

Quest Toad or Red Gate SQL Compare would be the most likely options.

Answer 2

ER/Studio , see http://www.embarcadero.com, will do most of what you're looking for, except for the data comparison. It is pricey however.

Answer 3

I'd give a try to "SQL Server Migration Assistant for Oracle (SSMA for Oracle)"

http://www.microsoft.com/sqlserver/2005/en/us/Migration-oracle.aspx

It will be really useful to you for points 1 and 3.

I used it with some data migration work, and although it didn't solved everything by itself, it really saved me a lot of time.

Answer 4

For the Data comparison, you can use a tool called Columbo. The comparison can be simple as drag-and-drop files or copy-paste tabular data, or more complicated SQL query results, down to full hierarchical compares and drill-downs through comparison results.

(Compare data across formats)

Answer 5

I'd like to clarify Red Gate's position. SQL Compare is currently SQL Server only but we intend to release Schema Compare for Oracle in the first half of 2010. In the meantime we have an Early Access Program. You're welcome to sign up if you want to try influence the direction of our tool and/or try out our early releases.

http://www.red-gate.com/Products/schema_compare_for_oracle/index.htm

Update: Early Access releases are now available and are completely free to use until the full release is out. Please visit the URL above for the download link as well as to sign up for updates.