« 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:
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@...
**********************************************************************
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@...
**********************************************************************
« Return to Thread: Near realtime replication of a v11 database to sql server?
| Free embeddable forum powered by Nabble | Forum Help |
