Oracle migration to sql server

Question

Oracle migration to sql server

Navigation

#1 by (1 votes)

0

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

sql sql-server oracle

asked by anonymous 12.12.2018 / 19:28

1 answer

SELECT DISTINCT in column of type JSON in postgresql Validation classes Laravel

score 1 · Answer 1

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

For the process of periodically synchronizing the SQL Server database with data from Oracle Database, one option is to bind servers. See Create Linked Servers .

There is also the option of using transactional replication through Oracle publishers; see Oracle Publishing Overview . But it's much more complex ...