• Lynn Pettis (8/9/2012)


    I don't think you will find a tool that will compare the schemas of different RDBMSs. The differences in datatypes alone could make this difficult. For instance, SQL Server as the BIT and TINYINT data types and there is not an equivalent in Oracle.

    There are tools that you can use to convert from one Database to another and they handle data type conversions, etc.

    http://www.embarcadero.com/products/er-studio

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/