| 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 |
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.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 3060.1 | ANSI SQL? | METSYS::HELLIAR | http://samedi.reo.dec.com/ | Mon Mar 17 1997 16:05 | 20 |
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
| |||||