i thinking efficent solution migration between 2 databases, both oracle. idea use db-link, create functions , procedures copy data 1 schema other schema, can not use oracle data pump because new database has new schema so, oracle data pump not usefull me. know/try other ways ?
edit: tables has different names/column names. structure of tables different too. part of migration used once (around 10% of data) second part use few times. migration of 90% of data in downtime. database contains more 2 bilion rows.
if time permits , have microsoft visual studio, can ssis packages perform data migration installing ssdt on visual studio. i've done similar db migration, however, oracle db sql server.
you may create separate ssis packages perform different parts of migrations according needs.
some references below started.
Comments
Post a Comment