🚀 go-pugleaf

BTW we also use federation as a migration strategy so that the company does
not have to wait for the new, consolidated database to become available
before moving forward. Its call MetaMatrix Information Integration Server.

Thats because we not only federate but also provide a way to graphically
specify transforms between the data so that the results of the federated
access look just like the converted/merged databases. SO you can merge the
two databases immediately (usually done in days or small number of weeks) &
access them as a virtual database with a structure of a different, merged
database.

Old apps can use the old databases, new apps can use the merged virtual
database.
Then when you wish to actually execute the conversion, you can use the
server to convert - beauty is that the new apps are already constructed to
use the new database.

Makes many more options available to project staff & provides the benefits
immediately.
Clearly you can also use this to test if the merge of data is worth it,
without incurring too many costs.

Regards,
               David Penney
               CTO-Europe
                http://www.metamatrix.com
"LKH" <alexlkh@tm.net.my> wrote in message news:3ca7e95a_2@news.tm.net.my...
> Hi all,
>
> I am doing study research on convert or federate database. Which would be
> the best or better 'method'? I will also invertigate the costs, advantages
> and disadvantages of both options.
>
> The senario is such:
> 2 companies are to be merged. But both companies have databases dealing
with
> similar data to support the same business functions.Data is similar but
all
> table, field and format is different. Therefore the company can either
> convert one or both databases to a common format or can interface to both
of
> them through a gateway.
>
> I am this is not confusing.
> If you of any documents, urls, white papers, technical papers that
concerns
> with the above please forward them to me. Thanks a lot. Please also advice
> on the above. Your opinions are very valuable to me.
>
> Again thank you very much for your time.
>
> KH
>
>
>
>