Migration oracle to sql server

Asked

Viewed 111 times

-1

Can anyone indicate me a good data migration tool for the oracle database to the sql server database and vice versa? I need to take a lot of records from the oracle database and save it in the sql server database, I need the migration to be done in a period of time too, for example: Every 20 minutes take an x amount of data from oracle to sql server. If anyone knows and can leave the documentation will also help me a lot.

sql sql-server oracle migration

  • Try asking your question on this site https://serverfault.com

  • https://docs.microsoft.com/pt-br/sql/ssma/oracle/sql-server-migration-assistant-for-oracle-oracletosql?view=sql-server-2017 Microsoft import tool... follow documentation, there are download links tbm

  • @Tacila It seems to me that what you are asking for is not migration but synchronization or replication of databases.

1 answer

1

For migration you can use the Migration Assistant (SSMA) to Oracle, which documentation is available at Introduction to the SSMA for Oracle.

For the process of periodically synchronizing the SQL Server database with data from the Oracle Database, one option is server binding. Vide Create linked servers.

There is also the option to use transactional replication through Oracle publishers; see Oracle Publishing Overview. But this is much more complex...

  • Thank you very much, my friend!

Browser other questions tagged sql sql-server oracle migration

You are not signed in. Login or sign up in order to post.