🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.replication
Article #100

Re: Replication from IB to MS SQL

#100
From: Notra Damus
Date: Tue, 07 Oct 2003 06:55
33 lines
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-mail
References: <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