| 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,
Who can tell me how DECEDI Unix determines wich database to use on
startup.
It is possible of course to have multiple types of databases running on
a given server.
Also when DECEDI is not started, access to the database remains possible
through SQL/ODBC.
I can imaging that in situations of migrating databases from one type
of the other you have the following scenario.
- DECEDI is configured to use database 'A'
- use decedi_config to create a database of type 'B'
- use decedi_must and decedi_dlg to load the edi tables
- Restart DECEDI with the old database 'A'
- Now it is possible to configure the database 'B' through ODBC only
- When the configuration is complete, stop DECEDI and start it from
database 'B'
- migration complete (skipped a few things ;-))
Any comments?
GJ
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 3107.1 | Easy or could be hard | METSYS::HELLIAR | http://samedi.reo.dec.com/ | Fri Apr 25 1997 10:53 | 17 |
GJ,
It is very easy to have different vendor types on the same machine
(oracle 7, informix, Oracle rdb) and most of our EDI developement machines
have mutiple vendor databases (the only gotcha is a clash between
Oracle 7 and oracle Rdb) over libsql which both provide but that can be
worked around. Switching the database impolementation is just a case
of setting the nsoftlink from our database shareable library to point
to the vendor specific one in use.
If you want multiple database instances of the same vendor type then
that's more difficult. Our database is called decedi_db (or decedidb
for oracle7). Without going through the entire exercise for the
particular database vendor I could not guarentee that multiple DEC/EDI
database instances could or would work.
Graham
| |||||
| 3107.2 | IJSAPL::DEWIJK | GJ from the Dutchlands | Fri Apr 25 1997 15:11 | 8 | |
Hi Graham,
In the 'simple' case,
what do I have to do to switch from Oracle RDB to Oracle 7
and vice versa?
GJ
| |||||
| 3107.3 | METSYS::THOMPSON | Fri Apr 25 1997 16:11 | 7 | ||
Hi, decedi_config does the switch. Mark | |||||