August 9, 2012 at 4:32 pm
I'm dealing with constant Oracle Schema changes and I need to synchronize my SQL Server Tables with changes that are made in Oracle which I do not make and I'm not on top of what is changing when.
There are hundreds of tables that I need to keep track of.
I need a good tool that will compare Oracle tables to SQL Server Tables.
Your recommendations would be greatly appreciated.
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/
August 9, 2012 at 5:13 pm
So far I found these two tools.
http://www.sqlaccessories.com/Download.aspx
http://www.dbsolo.com/schema_comparison.html
Does anyone have any recommendations, suggestions, etc?
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/
August 9, 2012 at 5:23 pm
It appears that neither of these tools can perform a compassion from one Database vendor to another. Oracle to Oracle, SQL Server to SQL Server, etc.
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/
August 9, 2012 at 5:28 pm
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.
August 9, 2012 at 5:51 pm
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/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply