Page 1 of 1

Merging non inherited schemas.

Posted: Wed Oct 05, 2011 8:49 pm
by Dr Danyo
Hi folks, Just testing the waters to get a feel for what our options might be;

Does anyone have any experiencing merging non inherited schemas together (included data) :?:

For extra points, the schema being merged contains a number of packages which are imported by the target schema (this is kinda of our reason for considering merging, to reduce the number of packages)

- Dr Danyo.

Re: Merging non inherited schemas.

Posted: Wed Oct 05, 2011 9:27 pm
by torrie
I inherited a system which had a lot of subclasses in a sub schema. We merged the schemas in a new Jade system ensuring that the class structure of the persisent data classes was the same. (We moved some properties onto superclasses but the properties had the original names and types.) We then used the JADE Dump and Load utility to move the data from one system to another. You may need to ensure that the class numbers are the same.

This wouldn't work very well on a large system, but worked OK for a smallish one, I think it was about 2GB at the time.

Re: Merging non inherited schemas.

Posted: Wed Oct 05, 2011 10:24 pm
by Dr Danyo
Thanks Torrie, gut feel, how long did it take to move the data for 2GB?

- Dr Danyo.

Re: Merging non inherited schemas.

Posted: Thu Oct 06, 2011 9:40 am
by torrie
I guess a few hours. It was an over night upgrade on the system. Practically, disk space can become an issue, using separate disks is likely to be faster. You may be able to dump on one server and load on another spreading the load.