Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old June 18th, 2009, 06:49 AM
nvalchanov nvalchanov is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2009
Posts: 1 nvalchanov User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 15 sec
Reputation Power: 0
MS SQL Server 2008 replication design

Hi all,

I'm new to MS SQL Server replication and I have to design a replication solution to the following problem:

We have implemented an ERP system for the retail industry with POS and back–office (invoices etc.) functionality.
The system has to be installed in several different stores and I have to setup replication between them.

I am considering to do the following:

1. Install a main server in Store1 and create a publication.

2. Have a backup server in Store1 which subscribes to the publication and synchronizes every 15 minutes.

3. Have a second server in Store2 which subscribes to Store1 and synchronizes every 1 hour.

4. Republish everything on Store2 and have a backup server in Store2 which subscribes to Store2 and synchronizes every 15 minutes.

There are two stores currently.

5. Later on we need to make all POS terminals (8) of them in each Store1 and Store2 subscribe to the publications in Store1 and Store2 respectively so that they can work in offline mode.

I am wondering if my solution seems good and if anybody can suggest anything better.

Currently I have the Store2 server’s subscriptions as push i.e. Store1 pushes the changes and the distributor
is running on the same machine. Also the server is used for everything, including reports.
I am researching an option for making a separate server for the distributor and wandering where to setup
pull and where to set up push subscriptions.

Any suggestion on possible solutions will be appreciated.

Thanks

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > MS SQL Server 2008 replication design


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump




 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.

Request Your Free Technology Downloads!
 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.

Request Your Free Technology Downloads!
 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.

Request Your Free Technology Downloads!
 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.

Request Your Free Technology Downloads!
 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.

Request Your Free Technology Downloads!
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 




© 2003-2009 by Developer Shed. All rights reserved. DS Cluster 1 Hosted by Hostway
For more Enterprise Application Development news, visit eWeek