[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference rocks::dec_edi

Title:DEC/EDI
Notice:DEC/EDI V2.1 - see note 2002
Moderator:METSYS::BABER
Created:Wed Jun 06 1990
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:3150
Total number of notes:13466

3060.0. "Migratie from Oracle RDB -> Oracle" by UTRTSC::SMEETS (Workgroup support) Mon Mar 17 1997 11:53

Hi,

Last year a customer installed DEC/EDI V3.1 with Oracle Rdb V6-1.3. At the
moment he runs V3.1A still with Oracle Rdb V6-1.3.

As the Oracle V7 RDBMS is the company's standard. The customer would like to
migrate from Oracle Rdb towards Oracle V7.

The customer's question is how to migrate the EDI Rdb database towards the 
Oracle V7 database without losing data.

Any idea to accomplish this.

I've already thought of the following:

1. Make sure there are no documents and TF's in the database -> secondary 
   archiving
2. Export all profiles via the Cockpit.

But how about Tables, Management Services and Communications details.

Thanks in advance,


Martin
T.RTitleUserPersonal
Name
DateLines
3060.1ANSI SQL?METSYS::HELLIARhttp://samedi.reo.dec.com/Mon Mar 17 1997 19:0520
    Martin,
    
    One way is to generate 'ANSI SQL statements' as these have the
    best chance of working between databases. Although with V3.1A we have
    dropped generating ANSI SQL dumps of the database from decdi_config,
    the utility that did it is still in the kit, /usr/sbin/decedi_dump_db.
    
    So, for Oracle Rdb try:
    
    	/usr/sbin/decedi_dump_db -sRDB -o/tmp/rdb_dump.sql all
    
    Then try altering it to conform with Oracle 7 syntax and reload it
    using either SQL*Plus or svrmgrl. Watch out for the date/time fields as 
    these as most likely to be non-conformant.
    
    Obviously, switching databases is an ideal consulting opertunity so if
    you note down what needs to be changed then maybe some 'awk' expert
    could write a scipt for those that dare to follow you.
    
    Graham