Re: Migrating Des2k applications

Dave,

One solution may be to export the dev repository owner, drop the production owner objects and then import just the owner and not the entire database.

Another option is to just truncate the production repository tables and perform
an import.

All of the repository objects should be under a single user. You probably need to recompile invalid objects after the import. I do not see any solution
using the existing Designer 2k utilities.

Phil Cook

Dave Easeman <dave.easeman_at_bluefin-analysis.com> wrote in article <33436E16.47FF_at_bluefin-analysis.com>...
> Can anyone help with this requirement: I want to migrate applications
> between two repositories but the existing methods do not fully meet my
> requirements.
>
> I am using the API in a live operational repository to perform
> operational procedures such as dropping and recreating indexes to apply
> changes to storage parameters, etc. I have separate repositories for
> development and live but cannot find an easy way of migrating changes
> from development to live other than a full database export/import. I am
> using application versioning and there is a degree of sharing between
> applications.
>
> I cannot migrate at application level because the application import
> utility does not allow versions of an application! I have tried the
> unload/load and the check out/in utilities but they do not deal with
> deletions and also caused various other problems.
>
> I have a utility that compares application versions between repositories
> using the API and the meta model definition. This utility lists the
> differences between the applications but I do not have any time to amend
> the utility to do updates/inserts/deletes.
>
> I am currently using version 1.3 of Des/2000 on 7.2.3 server.
>
> Any information that may help would be much appreciated as Oracle have
> been unable to help.
>
> Regards
>
> Dave Easeman
> ----------------------------------------------------
> Dave Easeman - dave.easeman_at_bluefin-analysis.com
> WebSite - http://www.bluefin-analysis.com/
>
Received on Mon Apr 07 1997 - 00:00:00 CEST