0

I have test data copy from Oracle database to SQL Server. Data will be copied every hour. Data in Oracle is constantly changed and in SQL Server it will be in read-only mode.

| improve this question | |
  • Do you have a way to control what data is being copied? Can you get snapshots of the Oracle database at the time the data is copied? Is the data being transformed in any way? Do you have full access to both databases? – Kate Paulk♦ Aug 28 '18 at 11:21
1

That's a pain. The tools which claim to be able to do it require a fat wallet and expertise. This is basically a DB migration project.

A DIY way would be:

  1. Connect to your Oracle DB with any tool and copy the table structures.
  2. Find the SQL Server data type equivalent of each column
  3. Create the same tables in SQL Server with the adequate types
  4. Dump the data from Oracle into CSV files
  5. Import the data into your SQL Server

You have to keep in mind that these are two vastly different database management systems. Your best bet is to simplify the structure as much as you can: do away with primary keys, constraints, partitions, schemas, indices etc. If you manage to do that, you can then put a part of it in a script to handle the incremental updates.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.