November 17, 2008 at 5:05 pm
Hi all,
I have a quick question and hope you can provide some insight into this design question.
We have the following scenario:
We have a CRM / e-business application that runs on a SQL Database.
The application has two components
1. Windows Client (CRM administration finance etc) W32 Application is on site
2. Web front end (provides customers with the ability to access their accounts records etc via web browser)
We run into the following Scenario. The company is looking to provide access to the web front end to about 5000 members.
What i would prefer to do is put a box with SQL server and IIS Web front end in a colo with 100mb and have the public access it there.
We have a 2/2MB dedicated E1 link to the colo - So i was thinking of having the second SQL Box on the local site and have clients accessing that box locally.
I was then thinking of setting up some form of replication between both boxes.. Not sure what replication is best i was reading the transactional replication might be best.
The problem in this scenario is that change can and will be happening to both Databases.
E.g. online users can be modifying details - while local client users can also be modifying details... The database is the same but it has two sources modifying it. I am not sure if or how replication can work in this form.
Sorry that my question is long but hoping to get some basic points out in that.
1. Is it possible to run something like bi-directional replication against the same database. e,g, replication from source to target and target to source?
2. Can replication cycles be adjusted to compensated for link speed?
Thanks a lot for your help
Cheers!
November 18, 2008 at 7:58 am
You would be looking for MERGE replication. Check it out in BOL. If you do go with merge replication you may be able to save some $'s by using Sql Server Express at the colo, if that is a consideration for you.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 18, 2008 at 9:05 am
Yup follow what's been suggested here. MERGE would be your choice.
November 18, 2008 at 3:16 pm
Hay Guys thanks for the feedback. I will start looking at MERGE replication. If any one has any links they think would help please pass them on
Thank you! 🙂
November 18, 2008 at 3:23 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply