Article View: borland.public.interbase.replication
Article #100Re: Replication from IB to MS SQL
From: Notra Damus
Date: Tue, 07 Oct 2003 06:55
Date: Tue, 07 Oct 2003 06:55
33 lines
2171 bytes
2171 bytes
"Bryan Marks" <bmarks@maritimetravel.ca> wrote in message news:3f7c122e@newsgroups.borland.com... > Does anyone know anything about replicating from IB to MS SQL? > > I found a site on the web that said they had a product to do such a thing, > but they never responded to my request for information - (and there is no > other contact information on the site other than the RFI form). > > Any help or information on potential resources would be appreciated. > > Bryan > Bryan, IMHO, it is better if you wrote your own app to do such a thing. Programs from a third party who have no idea of your architecture, databases etc. would not be absolutely perfect in getting the job done. Even if it did, there would be some minor workarounds needed for it to work. Basically you would write a data transfer app which accesses both databases and transfers data from tables in the required direction. You would run this app at a pre-defined time or during off-peak hours so as not to degrade performance for users who are using either database. Of course you would need Delphi Ent Ed. just a suggestion.. ND
Technical Details
Message-ID:
<3f82eaa1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-04!sn-xit-06!sn-xit-05!sn-xit-08!supernews.com!newsfeeds.sol.net!news.maxwell.syr.edu!newsfeed.tpinternet.pl!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3f7c122e@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f89d7,c686b7918c73125 X-Google-Attributes: gidf89d7,public X-Google-ArrivalTime: 2003-10-07 09:41:10 PST Reply-To: "Notra Damus" <nostradumbass77@yahoo.com> From: "Notra Damus" <nostradumbass77@yahoo.com> Newsgroups: borland.public.interbase.replication References: <3f7c122e@newsgroups.borland.com> Subject: Re: Replication from IB to MS SQL Date: Tue, 7 Oct 2003 12:25:12 +0530 Lines: 35 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 61.1.75.118 Message-ID: <3f82eaa1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1065544353 61.1.75.118 (7 Oct 2003 09:32:33 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-04!sn-xit-06!sn-xit-05!sn-xit-08!supernews.com!newsfeeds.sol.net!news.maxwell.syr.edu!newsfeed.tpinternet.pl!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail