Does SAP Business One Support Database Replication?

[Former Member]

Dear All,

Does SAP Business One support database replication? For Disaster Recovery, we try to replicate our SAP B1 production database (company, rsp, sbo-common database) to another machine (DR Server) which doesn't have the same hardware key with the production's. Is it possible to run the SAP B1 on DR Server by using Production license and without importing a new license for DR Server?

Note: SAP B1 on DR server is connected to Production License Server.

Thanks.

Regards,

Alfa

[Former Member]

Hi Ryano,

You can backup and restore by RSP. Please check the documentation helps you.

Remote Support Platform

https://websmp105.sap-ag.de/partneredge/B1/rsp

Frequently Asked Questions

https://websmp105.sap-ag.de/~sapidb/011000358700000183932009

http://scn.sap.com/community/business-one/blog/2013/05/06/remote-support-platform-rsp-and-its-benefi...

Regards,

Marcelo Silva Santos

[Former Member]

Hi all,

Can i use tablediff in sql server to synchronise data between two databases in which one ios connected to SAP. Thank You.   

[Former Member]

Hi Alfa,

Please refer to article: http://technet.microsoft.com/library/Cc917680

https://scn.sap.com/thread/1059313

Regards,

Kiran

[KennedyT21]

Hi Alfa Ryano Yohanis

You can use Log shipping and clustering for the disaster recovery.. Replication is not supported

Hope helpful

Regards

Kennedy

[Former Member]

Hi,

This is SAP Note 942923 content

Symptom

High availability solutions in SQL Server such as MS SQL Server Cluster Service, MS SQL Server Log Shipping Service, indexing/indices, Database Replication : Are they supported with SAP Business One?

Cause

Information

Solution

SQL Clustering,Log Shipping, are currently supported in SAP Business One Version 8.82.

SQL Clustering is supported with the following operating Systems

                Windows Server 2008R2  with Failover Cluster Service on SQL Server 2008 R2

                Windows Server 2008R2

SQL Log Shipping is supported with the following versions:

               SQL Server 2005

               SQL Server 2008 /R2

SQL Replication is currently not supported in SAP Business One for the following reasons:

There are 3 types of replication for transactional data:

-          “Transactional replication”, encrypted stored procedure cannot be replicated, as Business One works with  encrypted stored procedures it will fail to work with the replicated company DB.

-          “Transactional publication with updatable subscriptions”, will add an unique identifier column ‘MSrepl_tran_version’, which will fail a SAP Business One upgrade.

-          “Merge publication”, same as above

Hope this helps,

TVSon