Kbase P95697: Can a Progress 9.1x and OpenEdge 10.0x database be synchronized using schema triggers ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/10/2004 |
|
Status: Unverified
GOAL:
Can a Progress 9.1x and OpenEdge 10.0x database be synchronized using schema triggers ?
FACT(s) (Environment):
Progress 9.1D
OpenEdge 10.0x
FIX:
This is possible.
However, keep in mind that even though the schema triggers are defined in the database, they are actually executed on the client.
Because of this, synchronizing databases using just schema triggers is only possible if the following conditions are met:
- The triggers in the Progress 9 database do not check CRC
- The trigger code is compiled using OpenEdge 10
- All clients connecting to the databases are OpenEdge 10 clients (as Progress 9 clients will not be able to connect to the OpenEdge 10 database).
A better alternative would be to implement AppServers - as long as no OpenEdge 10.0x specific features are used, a Progress 9.1x client will be able to connect to an OpenEdge 10.0x AppServer. If the triggers are then written to pass the data to the appropriate AppServer procedure instead of directly to the databases, the client version will not matter.