Load schema files under new schema name

[ConvertFromOldNGs]

by ACA >> Fri, 9 Aug 2002 3:08:52 GMT

Afternoon All,

Has anyone take a copy of one systems schemas and put them back into the same environment under a different schema name and changed the map files to be a totally different set from the originals?

The new system works find but the old system is giving this error:

3082 (Attempt to change the name or number of an existing database file).

Anyone got any ideas what I might have done wrong?

Cheers

Michael Hill
ACA

[ConvertFromOldNGs]

by allistar >> Sun, 11 Aug 2002 21:10:48 GMT

Hi there,
Create the new schema manually and add all of the new map files into it, then import your schema with a "target schema" of that new schema. You may have to fiddle the .scm file during the load as it may
complain about not allowing more than one Application class subclass
(and global and web session).

Hope this helps,
Allistar. ------------------------------------------------------------------
Allistar Melville
Software Developer
Auckland, NEW ZEALAND

Greentree International,
Developer of Greentree Financial Software. ------------------------------------------------------------------

[ConvertFromOldNGs]

by torrie >> Mon, 12 Aug 2002 12:13:25 GMT

Hi

I have done this with an existing system as well but not had both sets of the schemas in the same database. I take it you did this in a system with no data, ie not all the map files had been created yet? What probably went wrong is that you didn't give the map files in the new system new numbers, different from those in the existing system, either that or you have map files with the same name in both schemas but different numbers. I would guess that each map file in the jade database should have a unique map file number as well as a unique name.

Torrie Moore