Re: ANN: Database schema synchronization

From: Chris M (chris_at__takethisout_eventsoft.com)
Date: 03/18/05 

Date: Fri, 18 Mar 2005 10:11:22 -0700

Can you...?

        Add rules in to tell how to pupulate a new field? before it deletes the
old field that used to have that information? Such as, I have a
smallint field tha stores 0 or 1 and I have just changed the schema so
that it will be a char(1) and hold 'T'/'F'. I have to make sure the
schema is updated in such a way so that it adds the new char(1) field,
then updates it based on the old smallint field and then removes the
smallint field so that no information is lost.

Also, does it have the ability to run insert/update/delete statements
per each new schema adjustment? such as I am now adding a unique
constraint to my field but I first need to go and update the column and
make sure there are no conflicts in it. Or I am adding a Foreign Key
and I have to first make sure that the column that never before required
it does contain valid values?

Also, if i change a table name can it move all the data from the old
table into the new before wiping out the new one?

This is the kind of thing I have been looking for recently.

Thanks

Era Soluzioni wrote:
> Era Soluzioni announces the initial release of DbUpdater 1.0
>
> We're pleased to announce the availability of the DbUpdater32 1.0, an
> easy-to-use program which synchronizes database structures using the
> DbUpdater technology (http://www.erasoluzioni.com/DbUpdater/).
>
> Our purpose is to disclose the DbUpdater technology to a wide range of user
> and get a feedback in order to improve our architecture.
>
>
> What is DbUpdater32
>
> DbUpdater is ideal for software farms which have the problem of taking the
> customer data structure synchronized with the actual database structure.
>
> All the process is governed by a set of configuration files where is
> possible to specify which objects (tables, stored procedures, views,
> indexes, .) synchronize and how (create, modify, delete, .).
>
> DbUpdater does not requires a live connection: when development team needs
> to update customers, it extracts the database schema (step 1), send schema
> to the customer and prepares the required sql instructions "on the fly"
> comparing actual database schemas with customer database structure.
>
> In addition, the component can update databases which are installed in
> different providers. For example, if the actual database has been developed
> and maintained with SQL Server and if the customer provider is Sybase
> Adaptive Server Anywhere (ASA), the program can takes the two database
> synchronized.
>
> If you are interested, visit the our site at
> http://www.erasoluzioni.com/DbUpdater/. To download the DbUpdater32 for
> free, visit the http://www.erasoluzioni.com/DbUpdater/dbupdater32Info.htm
>
>
> Any kind of feedback is welcome at
> DbUpdater@erasoluzioni.com
>
>
> Best Regards,
> Era Soluzioni
>
> http://www.erasoluzioni.com
>
> support@erasoluzioni.com
>
>
>