Showing posts with label branches. Show all posts
Showing posts with label branches. Show all posts

Wednesday, March 21, 2012

Replication between branches

Good Morning,
I have a dude with a new SQL implementation.
The scenario is a Central office with an SQL server and 10 branch offices
with sql server too. I need to replicate branches data Base with the central
sql.
All the branches could see the same DB.
It is possible to implement with SQL standard?
Or I need the Enterprise edition?
Thanks
Yes - Standard Edition is fine. You might also want to take a look here:
http://www.replicationanswers.com/CentralSubscriberArticle.asp
It might be that this is not the correct implementation - depends on other
factors eg can the branches change each other's data or is it completely
segregated?
Paul Ibison
|||Paul,
The Data can be changed by all the branches.
"Paul Ibison" wrote:

> Yes - Standard Edition is fine. You might also want to take a look here:
> http://www.replicationanswers.com/CentralSubscriberArticle.asp
> It might be that this is not the correct implementation - depends on other
> factors eg can the branches change each other's data or is it completely
> segregated?
> Paul Ibison
>

Monday, March 12, 2012

Replication Advice needed

Hello,

We are developing a software for a logistic company, which will have around 1000 branches, and we need to synchronize the database(SQL Server) between all the branches using the database at web server, i.e the branches can get the new data from the web server,as well as push the data at the web server, please tell us how can we accomplish this task,

ThanksThis wont work if I'm reading this correctly. You want to have a server both receiving and pushing data. Besides using it as the web server and replication on one server to feed 1000 sites. I say get 4 deal Racs Use
1. database server
2. replication server
3. webserver
4. backupserver.
at sites, have 2 server interfaces and one for live and the other for replication. Users should never get the live data. They only see the replication and thats transparent to them. Hope this helps. I'd also checkout lazydba.com real good info