?
Solved

SQL Server replication reference SAP

Posted on 2010-11-07
4
Medium Priority
?
860 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 2000 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

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

765 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