Oracle vs. SQL Server schema compare

I am in a situation where there are two parallel projects (one oracle and on
e
MS SQL) and I need to keep track of the schema differences between each
database. I know there are some tools out there like SQL red gate that
compare between MS SQL but does anyone know of any tool that can do this
across db platforms?You can query the system information tables that SQL Server uses to store
things like objects schemas. The system tables are probably different in
Oracle so the query will be different as well, but the concept is the same.
http://www.aspfaq.com/search.asp?q=schema
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:BEA5052B-6423-41D8-8D0A-558BD31955D7@.microsoft.com...
>I am in a situation where there are two parallel projects (one oracle and
>one
> MS SQL) and I need to keep track of the schema differences between each
> database. I know there are some tools out there like SQL red gate that
> compare between MS SQL but does anyone know of any tool that can do this
> across db platforms?|||>From your requirements, it seems like the open-source SchemaCrawler
tool will do what you need. SchemaCrawler can output details of your
schema (tables, views, procedures, and more) in a standard and uniform
way across different DBMS systems, such as Oracle and SQL Server.
SchemaCrawler is free, open-source, cross-platform (operating system
and database) tool, written in Java, that is available on SourceForge,
at:
http://schemacrawler.sourceforge.net/
You can use a standard diff program to diff the current output with a
reference version of the output. SchemaCrawler can be run either from
the command line, or as an ant task. A lot of examples are available
with the download to help you get started. You will need to provide a
JDBC driver for your database. No other third-party jars are required.
Sualeh Fatehi.