« Return to Thread: Near realtime replication of a v11 database to sql server?

Re: Near realtime replication of a v11 database to sql server?

by Balinder Walia :: Rate this Message:

Reply to Author | View in Thread

Sounds good. Let me know if you need any advise on the way. Another thing is
presumably you just want to just push the data to SQL server and not sync it
back into v11.

2009/7/3 Arnold Cordewiner <Arnold.Cordewiner@...>

> I guess I'll be writing my own then. Thanks for your reply.
>
> -----Oorspronkelijk bericht-----
> Van: 4d_tech-bounces@... [mailto:4d_tech-bounces@...]
> Namens Balinder Walia
> Verzonden: vrijdag 3 juli 2009 12:22
> Aan: 4D iNug Technical
> Onderwerp: Re: Near realtime replication of a v11 database to sql server?
>
> Why not write your own? Is it because of the time constraints?
> I have written a generic data export routine using 4Dv11 USE EXTERNAL
> DATABASE to talk to ( Sybase ) using DSN which should work
> for MS SQL Server. If focused on one task it shouldn't take that long. It
> was written in v11.3 but I can re-write it for you in v11.4 if you wish.
> Best bet is to write your own as a component unless some one else has
> already done it as a component. Rest is entirely up to you.
>
> Cheers
>
> 2009/7/3 Arnold Cordewiner <Arnold.Cordewiner@...>
>
> > Microsoft SQl server 2005 enterprise on windows 2003 server 64 bit.
> >
> > -----Oorspronkelijk bericht-----
> > Van: 4d_tech-bounces@... [mailto:4d_tech-bounces@...]
> > Namens Balinder Walia
> > Verzonden: vrijdag 3 juli 2009 12:10
> > Aan: 4D iNug Technical
> > Onderwerp: Re: Near realtime replication of a v11 database to sql server?
> >
> > What is the destination SQL server vendor, platform and version etc?
> >
> > Sent from my iPhone
> >
> > On 3 Jul 2009, at 10:19, Arnold Cordewiner <
> > Arnold.Cordewiner@...
> >  > wrote:
> >
> > > I would like to have our data in 4D replicated 1 on 1 to an sql
> > > server for reporting purposes. After the initial replication, each
> > > change to the data in 4D should be visible in the replica in sql
> > > server within 15 minutes.
> > >
> > > Does anyone know of a plugin/3rd party app that can do this? Would
> > > rather not roll my own if I can avoid that.
> > >
> > > Arnold.
> > >
> > > ________________________________
> > > Dit e-mailbericht en alle documenten die ermee verzonden worden, zijn
> > > vertrouwelijk, wettelijk beschermd en uitsluitend bestemd voor
> > > gebruik door
> > > de persoon of de onderneming waaraan ze geadresseerd zijn. Indien deze
> > > e-mail verkeerdelijk bij U terechtkomt, gelieve de afzender te
> > > verwittigen
> > > en deze bestanden van Uw computer te verwijderen. Dank voor Uw
> > > medewerking.
> > > **********************************************************************
> > > Live Data Mapping Services with 4D v11 SQL
> > > See it for yourself - http://www.4d.com/solutions/ndwater.html
> > >
> > > 4D Internet Users Group (4D iNUG)
> > > FAQ:  http://www.4D.com/support/faqnug.html
> > > Archive:  http://lists.4D.com/archives.html
> > > Options: https://lists.4d.com/mailman/options/4d_tech
> > > Unsub:  mailto:4D_Tech-Unsubscribe@...
> > > **********************************************************************
> > **********************************************************************
> > Live Data Mapping Services with 4D v11 SQL
> > See it for yourself - http://www.4d.com/solutions/ndwater.html
> >
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://www.4D.com/support/faqnug.html
> > Archive:  http://lists.4D.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4D_Tech-Unsubscribe@...
> > **********************************************************************
> >
> > Dit e-mailbericht en alle documenten die ermee verzonden worden, zijn
> > vertrouwelijk, wettelijk beschermd en uitsluitend bestemd voor gebruik
> door
> > de persoon of de onderneming waaraan ze geadresseerd zijn. Indien deze
> > e-mail verkeerdelijk bij U terechtkomt, gelieve de afzender te
> verwittigen
> > en deze bestanden van Uw computer te verwijderen. Dank voor Uw
> medewerking.
> > **********************************************************************
> > Live Data Mapping Services with 4D v11 SQL
> > See it for yourself - http://www.4d.com/solutions/ndwater.html
> >
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://www.4D.com/support/faqnug.html
> > Archive:  http://lists.4D.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4D_Tech-Unsubscribe@...
> > **********************************************************************
> >
> **********************************************************************
> Live Data Mapping Services with 4D v11 SQL
> See it for yourself - http://www.4d.com/solutions/ndwater.html
>
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://www.4D.com/support/faqnug.html
> Archive:  http://lists.4D.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4D_Tech-Unsubscribe@...
> **********************************************************************
>
> Dit e-mailbericht en alle documenten die ermee verzonden worden, zijn
> vertrouwelijk, wettelijk beschermd en uitsluitend bestemd voor gebruik door
> de persoon of de onderneming waaraan ze geadresseerd zijn. Indien deze
> e-mail verkeerdelijk bij U terechtkomt, gelieve de afzender te verwittigen
> en deze bestanden van Uw computer te verwijderen. Dank voor Uw medewerking.
> **********************************************************************
> Live Data Mapping Services with 4D v11 SQL
> See it for yourself - http://www.4d.com/solutions/ndwater.html
>
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://www.4D.com/support/faqnug.html
> Archive:  http://lists.4D.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4D_Tech-Unsubscribe@...
> **********************************************************************
>
**********************************************************************
Live Data Mapping Services with 4D v11 SQL
See it for yourself - http://www.4d.com/solutions/ndwater.html

4D Internet Users Group (4D iNUG)
FAQ:  http://www.4D.com/support/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

 « Return to Thread: Near realtime replication of a v11 database to sql server?