Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
A
A
Alexey Sumin2013-05-30 14:15:17
Oracle
Alexey Sumin, 2013-05-30 14:15:17

Replication with transformation, how difficult?

Task:
Oracle DBMS has two schemes running on the same instance (RAC) - OLD_DB and NEW_DB, it is required to build one-way replication from OLD_DB to NEW_DB, for a long migration ~ 2-3 months.
The replica can be realtime or with a delay of 1-2 minutes.
There are ~100 tables, most of them repeat each other, only with the replacement of names or individual columns, and about 6 tables for which a serious transformation is needed, splitting one table into two (always or by value one field) and vice versa merging 2 tables into one.
Are there ready-made tools for such a task (of course, mapping will have to be done by yourself) and how difficult is this task in general?

Thank you in advance.

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)
Similar questions
A
Alexey Dabalaev2016-12-27 21:06:40
Hierarchical queries. Value generation. How to use INSERT INTO.... query? 1Reply
P
Parad1so2019-06-07 10:37:10
SQL how to link 2 tables varchar + number? 4Reply
A
artimf2015-01-22 08:47:15
How will a table be stored in Oracle if all possible indexes are created on it? 3Reply
M
Maxim Gerasimov2019-06-20 11:48:03
Why are nls parameters not set when creating an Oracle RAC 12c database? 1Reply
L
likilix2017-01-30 13:43:05
Data output problems from a stored function in apex. Who will help? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question