Re: HDR with Synchronous replication
rkusenet wrote: > "Francisco Roldan" <f_roldan@admcentralagricola.com.gt> wrote in > message news:cbcrq3$u35$1@news.xmission.com... > The other option we have is to use SQL Server replication, either log > shipping or transactional replication. Both are not as smooth as HDR. That's the understatement of the year. We have bugs logged with MS about transactional replication. They have ended up telling us that any high availability mission critical stuff with MS SQL should be done with clustering. Making any changes to the database schema is fraught. You can't simply update the main server and expect a schema change to proprogate to the secondary. There are in-built stored procedures for doing this that you can utilise but they can be problematic and you sometimes end up restarting the whole replication process again by rebuilding your publication and recreating a snapshot which impacts heavily on system performance. Don't go there! HDR is a dream to use and administer by comparison. Ben.
"Ben Thompson" <ben@nomonitorsoftspam.com> wrote in message news:10dlgniqbgmm24b@corp.supernews.com... > rkusenet wrote: > > > "Francisco Roldan" <f_roldan@admcentralagricola.com.gt> wrote in > > message news:cbcrq3$u35$1@news.xmission.com... > > > The other option we have is to use SQL Server replication, either log > > shipping or transactional replication. Both are not as smooth as HDR. > > That's the understatement of the year. We have bugs logged with MS about > transactional replication. They have ended up telling us that any high > availability mission critical stuff with MS SQL should be done with > clustering. > > Making any changes to the database schema is fraught. You can't simply > update the main server and expect a schema change to proprogate to the > secondary. There are in-built stored procedures for doing this that you > can utilise but they can be problematic and you sometimes end up > restarting the whole replication process again by rebuilding your > publication and recreating a snapshot which impacts heavily on system > performance. Don't go there! even without touching SQLServer replication, I can see it. I went thru their entire documentation and my reaction was: GOSH THIS SUCKS ROCKS. There is way too much manual steps involved in this. > HDR is a dream to use and administer by comparison. I know that. I have used it long time. However thanks to IBM it is very difficult for anyone to invest anything new in Informix. At least the GOLD bundle approach sounds better. Ben: I may need a favour from you. Can you reach me off-line. Your email id seems to be bogus. Thanks. Ravi
rkusenet wrote: > Ben: I may need a favour from you. Can you reach me off-line. Your email id > seems to be bogus. Thanks. Just remove the "no" and the "spam" from my e-mail address. Ben.