Re: Designer2000 - Reconcile Util

In Article<4krf99$9sd_at_nnrp1.news.primenet.com>, <pmc_at_primenet.com> write:
> Path: news.NetVision.net.il!psinntp!psinntp!psinntp!howland.reston.ans.net!newsfeed.internetmci.com!news.fibr.net!nntp.news.primenet.com!news.primenet.com!pmc
> From: Patrick Connors <pmc_at_primenet.com>
> Newsgroups: comp.databases.oracle
> Subject: Re: Designer2000 - Reconcile Util
> Date: 14 Apr 1996 11:14:01 -0700
> Organization: Primenet (602)395-1010
> Lines: 23
> Sender: root_at_primenet.com
> Message-ID: <4krf99$9sd_at_nnrp1.news.primenet.com>
> References: <4kij0c$eid$1_at_mhafc.production.compuserve.com>
> X-Posted-By: pmc_at_usr6.primenet.com
>
> Reinhard Bergander <100330.2165_at_CompuServe.COM> wrote:
> : After the first creation of the tables with the Database
> : Generator
> : and implemtation of the prototype, we had to changed some
> : information in the repository, e.g.
 

> : table test (field_A number(8), field_B number(8))
> : now looks like
> : table test (field_A number(8), customer_B number(8))
 

> : Is there any way using the Reconcile Utility to achieve this
> : without loosing any data in the existing tables ?
>
> Unfortunately, no. Once the physical tables have been created,
> Designer/2000 does not manage them any longer.
>
> You can still use Designer to change the DDL, but you will have to
> migrate the data from your prototype manually.
> --
> Patrick Connors
> pmc_at_primenet.com
>
> so THERE!

I must say the designer2000 does help in database maint. becouse it does have an alter database (in the reconcile utility) true, it does not deal with all the cases but READING the alter sql file will help you know what you need to do. Received on Thu Apr 18 1996 - 00:00:00 CEST