SQL Database Replication....
SQL Database Replication....
SQL Database Replication....
SQL Database Replication....
SQL Database Replication....
SQL Database Replication.... SQL Database Replication.... SQL Database Replication.... SQL Database Replication.... SQL Database Replication.... SQL Database Replication.... SQL Database Replication.... SQL Database Replication....
SQL Database Replication.... SQL Database Replication....
SQL Database Replication....
Go Back  Xtreme Visual Basic Talk > > > SQL Database Replication....


Reply
 
Thread Tools Display Modes
  #1  
Old 06-08-2014, 04:10 AM
lidds lidds is offline
Centurion
 
Join Date: May 2004
Posts: 100
Default SQL Database Replication....


I need some advise from the group.

I have developed a piece of software that uses MS SQL Server to store my application database. My software can be used by companies that have multiple offices in different countries, and this is fine as they write back to the SQL database in one of the locations. However I have one specific company who is using my software in both Toronto and Mumbai, the database is located in Mumbai. Normally this would not be a problem apart from the connection from Toronto to Mumbai has a 200ms latency. As you could imagine this causes huge response problems when they run my software from Toronto. What I want to be able to do is do some kind of database replication, therefore there would be an SQL database in both Toronto and Mumbai and you would connect to the database in your location. Doth of these databases would need to have read write access to them. What I then want to happen is any changes to the tables whether deletions, inserts or updates to also be replicated in the other location. I have already thought of a way to control which location has access to certain records. therefore stopping both locations from modifying the same record.

My question is how I can do this? Does MS SQL Server have this functionality already built in, the company is using MS SQL Enterprise? What would I have to change to my currently table structures to enable this to work?

Any help advise would be really appreciated.

Simon
Reply With Quote
  #2  
Old 06-08-2014, 09:56 AM
PlausiblyDamp's Avatar
PlausiblyDampSQL Database Replication.... PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

SQL Server has replication built in, however it isn't as simple as turning it on and expecting things to work.

http://msdn.microsoft.com/en-us/library/bb677158.aspx is a pretty decent starting point if you are looking at this kind of functionality.
__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
SQL Database Replication....
SQL Database Replication....
SQL Database Replication.... SQL Database Replication....
SQL Database Replication....
SQL Database Replication....
SQL Database Replication.... SQL Database Replication.... SQL Database Replication.... SQL Database Replication.... SQL Database Replication.... SQL Database Replication.... SQL Database Replication....
SQL Database Replication....
SQL Database Replication....
 
SQL Database Replication....
SQL Database Replication....
 
-->