Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Compare Oracle Tables to SQL Server tables Expand / Collapse
Author
Message
Posted Thursday, August 9, 2012 4:32 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:57 PM
Points: 4,242, Visits: 4,290
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/

Post #1343069
Posted Thursday, August 9, 2012 5:13 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:57 PM
Points: 4,242, Visits: 4,290
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/

Post #1343076
Posted Thursday, August 9, 2012 5:23 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:57 PM
Points: 4,242, Visits: 4,290
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/

Post #1343078
Posted Thursday, August 9, 2012 5:28 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:46 AM
Points: 20,801, Visits: 32,724
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.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1343079
Posted Thursday, August 9, 2012 5:51 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:57 PM
Points: 4,242, Visits: 4,290
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/

Post #1343081
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse