Solved

SQL Server replication reference SAP

Posted on 2010-11-07
4
839 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
  • 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Read about achieving the basic levels of HRIS security in the workplace.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

825 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