SQL Server replication reference SAP

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?
LVL 12
Norman MainaAsked:
Who is Participating?
TAB8Connect With a Mentor Commented:
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
Norman MainaAuthor Commented:
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?
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 ..  
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.