Forums

by JADE Kid - Ray Hidayat >> Tue, 14 Mar 2000 3:04:26 GMT

Is there a way to move one schema into another, without extracting, removing, loading?

I have found that having 16 Schemas floating around in nothingness is a bit confusing.
Extracting, removing, loading isn't such a great idea, because it takes quite a while.

Ray Hidayat
JADE Kid - 2000
www.jadekids.com
(Thanks to David Mitchell [JADE Kid - 1998] for the 'footer')

by Dean Cooper >> Tue, 14 Mar 2000 4:25:13 GMT

No. You need to extract the schema, and then use the schema load advanced options to load it as another schema.

Dean.

by rk >> Sat, 17 Jan 2004 23:30:47 GMT

just outta curiosity, is it possible to automate this say in JadeScript or some other way (i.e. so you don't have to extract/load 16 different schemas)??

rk

by allistar >> Mon, 19 Jan 2004 0:41:24 GMT

You can extract a schema using the jadclient application like this:

jadclient path=database-path schema=JadeSchema app=JadeBatchExtract endJade single abcschema.scm abcschema.ddb ABCSchema

That would extract the schema called "ABCSchema" for the database to files called "abcschema.scm" and "abcschema.ddb".

Look at pages 395, 396 and 397 in InstallAdmin.pdf for more details.

This will only extract the schema itself, not instances of any user classes in that schema.

You could then use jadloadb to automatically import those extracted schemas into another database.

Hope this helps,
Allistar.
--
------------------------------------------------------------------
Allistar Melville
Software Developer, Analyst allistar@silvermoon.co.nz
Auckland, NEW ZEALAND

Silvermoon Software
Specialising in JADE development and consulting
Visit us at: http://www.silvermoon.co.nz
*NEW* Simple web access to Jade at: www.silvermoon.co.nz/jhp.html ------------------------------------------------------------------