• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 868
  • Last Modified:

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?
0
NormanMaina
Asked:
NormanMaina
  • 3
1 Solution
 
TAB8Commented:
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
 
NormanMainaAuthor 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?
0
 
TAB8Commented:
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
 
TAB8Commented:
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now