Solved

SQL Server replication reference SAP

Posted on 2010-11-07
4
851 Views
Last Modified: 2012-05-10
I have five remote sites on point to point connections with the head office.
The point to point connections is very fast - a ping rely time of 2-7ms.

Each site has a sql server database ,and so does the HQ.

Because the point to point connections does go down from time to time , I want to set up merge replication so that users can work locally and then have an sql agent job to trigger the synchronization at scheduled times.

My question is in two bits -1,is the the best approach?
2)if the p2p link goes down while the job is synchronizing - will there be data inconsistencies - and how can i best handle that?
0
Comment
Question by:NormanMaina
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 10

Accepted Solution

by:
TAB8 earned 500 total points
ID: 34082182
Yes Merge replication is a good solution.

If the link goes down while syncing replication will just carry on for the last committed replication transaction so you data will always be in sync as all the data in the sys repl tables are time stamped so they can resolve any conflicts.. you can also put priorities on publisher vs subscribers for conflict resolution if you want  

Just be aware that you head office will be your publisher and your sub offices will be subscribers soooo  if you loose you Head office and have to restore from backup you will have to re snapshot all your subscribers to be the same as the head office and you could loose data ...  not a biggie you just need to plan for it now
0
 
LVL 12

Author Comment

by:NormanMaina
ID: 34082205
TAB8:>Thanks for your comment - am aware of how replication work - I have just never implemented it on SAP.
Have you ever dont it before?is there anything i should watch for? i.e tables exceeding 255 columns ,table or colum names too long etc and can bring out errors?
0
 
LVL 10

Expert Comment

by:TAB8
ID: 34087423
The thing you need to be aware of is that if new or temporary working tables are created withing sap these wont automaticly be created at the subscribers ..  
0
 
LVL 10

Expert Comment

by:TAB8
ID: 34087448
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question