N
Neil Treeby
Guest
Speaking as someone with experience performing Pro2 schema administration against a "live" product (3 separate in-house ERP-sized applications spread across 8 sites and 11 databases, split between client/server and AppServer replication) - yes, there is significant work involved in keeping all the schemas in sync. We have a monthly maintenance cycle so that translates to monthly diffs between the OE, SQL, schema holders, and Pro2 table/field mappings. Depending on the complexity and number of changes, it may take an hour or so. Add in the less periodic syncs on our non-production databases, and it can be quite a time sink. Granted, we are using a very old version of Pro2, so I don't know what tools exist in newer versions that make it easier to keep the dbs in sync.
Continue reading...
Continue reading...