This content has been marked as final. Show 3 replies
How to Migrate Sql server 2008 to Oracle 11g DB.This question is easy to answer. Use the SQL Developer Migration Workbench. Please start here: http://www.oracle.com/technetwork/database/migration/index-084442.html
But your description of what you want to do (splitting one SQL Server table into 5 tables on Oracle side) cannot be achieved with SQL Developer. At least not without much manual work.
Wouldn't it be easier to do the separation of the 1 into 5 tables completely on SQL Server side at first? Then the migration to Oracle using SQL Developer would be straight forward.
How to connect sql server and get the data and how to connect oracle server and check each and every value in equivalent table.If you are ready with the migration of metadata and data then you can use a database link from Oracle to your SQL Server database and can execute all queries that you want to compare data on both sides, using SQL statements. For that you need a gateway. There are two possibilities: The Database Gateway for ODBC (DG4ODBC), that requires a suitable ODBC driver for SQL Server, but the license for DG4ODBC is included in your license for Oracle RDBMS. Or the Database Gateway for MS SQL Server (DG4MSQL), which does not require a separate ODBC driver, but which must be licensed separately. Functionality of DG4ODBC is a little bit restricted compared to DG4MSQL, e.g. with DG4ODBC you can't use two-phase commit. About gateways I suggest to start reading here: http://www.oracle.com/technetwork/database/gateways/index.html
thankyou for you replay.
my doubt directly not migrate sql server to oracle (with my scenario).
how to data move one oracle server to another oracle server. both server with same structure(1 server in india and another server in usa).
Daily one time move the data from 1 oracle server to another oracle server.
i am try to "Data Loader 4.1" tool but connect not open error. i entered username and pwd, IP address, sid, portnumber But not connect.
I suggest that you post your question about moving data from one Oracle server to another Oracle server in a new thread and choose one of the forums that you find here:
We are experts for migrations of foreign databases to Oracle so you won't get much help in this forum about your new question.