RE: replicating an I-series home-grown application to a .net platform

OK I'll bite - could you please share what some of the major gotcha's were with the home grown replication systems that didn't work so well?

Thanks



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Friday, October 05, 2012 10:03 AM
To: Midrange Systems Technical Discussion
Subject: Re: replicating an I-series home-grown application to a .net platform

I've worked with multiple home grown replication...none of which
worked all that good... :)

There's a reason you pay big $$$ for commercial replication solutions.

I suggest hitting the iSeries directly. However, instead of hitting
the tables directly, consider building stored procs on the i that the
.NET app can call.

Charles

On Fri, Oct 5, 2012 at 10:25 AM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:

My company is replicating our I-series home-grown application to a .net platform for read-only. This .net app will provide customers with a typical web-based myAccount view as seen on many websites.

I have two questions for this forum:


1) For the read-only mirrored version on .net, does it make sense to have referential integrity (RI) constraints on file relationships? Either from a purist database design standpoint or from a common business rules standpoint? It seems to me that one HAS to assume that the source app has R-I that is intact, and it seems to be asking for trouble and headaches to try to enforce RI on a mirrored system that is read-only. This will require file loads and updates in a certain sequence, which could be problematic IMO.


2) Do other companies try to replicate an app onto another platform in almost real-time? It seems that it would be SOoooo much simpler to read the Iseries DB directly. Is this replication a common practice today? Or is it more suited to the 1990's?




______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.