Easy way to keep up to date several schemas (tables,procs, everything) to a master one ?
From: Sandor Feher <sfeher_at_bluesystem.hu>
Date: 27 Aug 2002 03:47:32 -0700
Message-ID: <9c0e1f5.0208270247.63720175_at_posting.google.com>
Hi folks,
Date: 27 Aug 2002 03:47:32 -0700
Message-ID: <9c0e1f5.0208270247.63720175_at_posting.google.com>
Hi folks,
I'm looking for a possible solution which can provide the following:
We have a master schema at my work the programmers and database admin work on. And there are several others at our clients everywhere. The schema name is the same everywhere. Is there any solution to keep the clients' schemas up to date to our one ? We have not syncronize the datas but the change of the tables (indexes,field modification),stored procs have to. Now we make this by hand. The exporting and importing the new tables is not acceptable in most of the cases.
I've tried some things e.g. user_objects' timestamp, and TOAD's related function but they seemed only an uncompleted solution to me. Any suggestion would be appreciated.
tia and bye., Sandor Feher
development manager Blue System Ltd.Received on Tue Aug 27 2002 - 12:47:32 CEST