convert or federate

Article View: bit.databases.mssql-l

Article #187

Back to bit.databases.mssql-l Previous Next

#187

From: LKH
Date: Mon, 01 Apr 2002 05:06

21 lines
2229 bytes

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: <3ca7e95a_2@news.tm.net.my>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!newsfeed.cwix.com!news1.tm.net.my

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fc5c9,4495fe2d92d89586,start
X-Google-Attributes: gidfc5c9,public
X-Google-Thread: 109f8c,4495fe2d92d89586,start
X-Google-Attributes: gid109f8c,public
X-Google-Thread: 10f47b,4495fe2d92d89586,start
X-Google-Attributes: gid10f47b,public
X-Google-Thread: f6611,4495fe2d92d89586,start
X-Google-Attributes: gidf6611,public
X-Google-Thread: ff0ac,4495fe2d92d89586,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: fdf39,4495fe2d92d89586,start
X-Google-Attributes: gidfdf39,public
X-Google-ArrivalTime: 2002-03-31 21:22:46 PST
From: "LKH" <alexlkh@tm.net.my>
Newsgroups: bit.databases.mssql-l,comp.database,comp.database.oracle,comp.databases,comp.databases.ibm-db2,comp.databases.ms-access
Subject: convert or federate
Date: Mon, 1 Apr 2002 13:06:16 +0800
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2462.0000
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2462.0000
NNTP-Posting-Host: kch-173-57.tm.net.my
X-Original-NNTP-Posting-Host: kch-173-57.tm.net.my
Message-ID: <3ca7e95a_2@news.tm.net.my>
X-Trace: news.tm.net.my 1017637210 kch-173-57.tm.net.my (1 Apr 2002 13:00:10 +0800)
Organization: TMnet Malaysia
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!newsfeed.cwix.com!news1.tm.net.my