Yes, it's only 1 way. Currently i'm thinking of putting a small bit of code in the trigger of every table. This code would populate a record in a special "replication work to be done" table in 4D that contains enough information to replicate the change in the 4D data to the remote database. Then have a process run on the 4D server that handles these records in chronological order and executes the data changes in the remote database.
-----Oorspronkelijk bericht-----
Van:
4d_tech-bounces@... [mailto:
4d_tech-bounces@...] Namens Balinder Walia
Verzonden: vrijdag 3 juli 2009 12:42
Aan: 4D iNug Technical
Onderwerp: Re: Near realtime replication of a v11 database to sql server?
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.html4D Internet Users Group (4D iNUG)
FAQ:
http://www.4D.com/support/faqnug.htmlArchive:
http://lists.4D.com/archives.htmlOptions:
https://lists.4d.com/mailman/options/4d_techUnsub: 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.html4D Internet Users Group (4D iNUG)
FAQ:
http://www.4D.com/support/faqnug.htmlArchive:
http://lists.4D.com/archives.htmlOptions:
https://lists.4d.com/mailman/options/4d_techUnsub: mailto:
4D_Tech-Unsubscribe@...
**********************************************************************