Article View: bit.databases.mssql-l
Article #189Re: convert or federate
From: shashi b mannepalli
Date: Mon, 01 Apr 2002 14:20
Date: Mon, 01 Apr 2002 14:20
35 lines
2489 bytes
2489 bytes
If the databases are big...it's better to convert one of them...Federated will have lot of Performance and Maintain issues... Thanks Bob Long <rclong@xmission.com> wrote in message news:<3CA7F11B.9607A91B@xmission.com>... > http://www.db2mag.com/db_area/archives/2002/q1/winter.shtml > > LKH wrote: > > > 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
Technical Details
Message-ID:
<7db8fc31.0204010620.23136dae@posting.google.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mailReferences:
<3ca7e95a_2@news.tm.net.my> <3CA7F11B.9607A91B@xmission.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10f47b,4495fe2d92d89586 X-Google-Attributes: gid10f47b,public X-Google-Thread: fc5c9,4495fe2d92d89586 X-Google-Attributes: gidfc5c9,public X-Google-Thread: 109f8c,4495fe2d92d89586 X-Google-Attributes: gid109f8c,public X-Google-Thread: f6611,4495fe2d92d89586 X-Google-Attributes: gidf6611,public X-Google-Thread: fdf39,4495fe2d92d89586 X-Google-Attributes: gidfdf39,public X-Google-ArrivalTime: 2002-04-01 06:20:19 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail From: shashitech@yahoo.com (shashi b mannepalli) Newsgroups: bit.databases.mssql-l,comp.database,comp.database.oracle,comp.databases,comp.databases.ibm-db2 Subject: Re: convert or federate Date: 1 Apr 2002 06:20:19 -0800 Organization: http://groups.google.com/ Lines: 35 Message-ID: <7db8fc31.0204010620.23136dae@posting.google.com> References: <3ca7e95a_2@news.tm.net.my> <3CA7F11B.9607A91B@xmission.com> NNTP-Posting-Host: 204.253.137.213 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1017670819 30909 127.0.0.1 (1 Apr 2002 14:20:19 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 1 Apr 2002 14:20:19 GMT