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.
On Thu, Aug 6, 2009 at 7:45 PM, Scott
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
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives