Re: Direction for Keeping Web DB up to date

[Charles Wilt <charles.wilt@xxxxxxxxx>]

How is that any different from impacting web server when when doing
maintenance on the MS SQL server?

Charles

On Fri, Aug 7, 2009 at 8:04 AM, PaultinNZ<paultormey@xxxxxxxxx> wrote:
> 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.
>
>
> --
> Paul Tormey
> 2/12 Ayrshire Place
> Somerville
> Manukau
> 2014
> New Zealand
> Home: 09 534 3469 or 0064 9 534 3469
> Mobile: 021 0654157 or 0064 210654157
> --
> 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.