| Data Migration [message #104185] |
Thu, 12 August 2004 11:08 |
Matt
Messages: 43
Registered: September 1999
|
Member |
|
|
I have two database instances: DEVL, PROD.
The Prod data is being used and was created last
year with a migration from devl.
Since then changes and additions have been made to
devl.
There are a set of tables in the devl instance
that will have some of these additions changes migrated
to prod.
There is a need for a tool, in house or third party
that will be able to find the differences between
both and then create the actual SQL insert and update
statements depending on the difference found between devl
and prod. (ie. we don't want to create an insert statement
for a row that already exist in prod, it need to make an update
one).
There is an idea to use PLSQL for this but it would
be harder to create the SQL statements.
This would be more of a quick fix than a real solution.
PLSQL is better suited for direct table changes using SQL
statements then created SQL statements.
Any help would be appreciated.
Client Operating System : Windows NT 5.0
Oracle Client Version : 8.1.6.0.0
Oracle Server Version : Oracle9i Enterprise Edition Release 9.2.0.3.0
Server OS: HP Unix
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
