One of the possible downsides of accessing the iSeries DB2 database would be
that if you need to do any maintenance on the iSeries you impact the Web
customer view. Might not be a big issue but just a thought.

Paul

2009/8/7 Charles Wilt <charles.wilt@xxxxxxxxx>

I'm with Scott on this one.

You can set up views that mimic the MS SQL server tables/views
complete with long names, so that the web app will require little if
any modification. You could even set up those views in a schema named
like the one on MS SQL server.

I've yet to see a "home grown" replication system that worked 100%
reliably. It's just never as simple as it looks. There's a reason
you'd spend big $$$ to purchase a vendor's replication package.

Charles

On Thu, Aug 6, 2009 at 7:45 PM, Scott
Klement<midrange-l@xxxxxxxxxxxxxxxx> wrote:
Why not have the web site query your DB2 for i database directly? Use a
firewall to ensure that your i's database is only accessed from the web
server.

This would be a lot simpler than trying to replicate the data from one
database to another.

--
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.





This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].