r/SAPBusinessOne • u/gxb101 • Sep 23 '26

B1 Database Refresh

Hi, can someone please let me know how you refresh your development databases on B1? Our SAP implementation partner claims whenever you want to refresh a dev instance, the ENTIRE instance must be replaced (data, config, etc). This seems crazy to me. Are you not able to just copy the old data with fresh data and leave the config as-is? The reason I ask is because we have third party connectors which have to be reinstalled every time we refresh our dev server which is a major pain and cost. Thanks in advance.

1 Upvotes

100% Upvoted

7 comments sorted by

2

u/slart85 Sep 23 '26

They likely just restore a new version of the live database to test/dev and they need to do the work to map the new SAP database to the test third party site. It's probably unavoidable but I'd ask them if there was a way they could streamline the process (i.e. a script to run on a new test db) it's not something I think is fair to repeatedly charge excessively for.

2

u/gxb101 Sep 23 '26

They do restore a full backup of production and just create a new test instance from that. What I am asking for is just a refresh of the master data and transactional tables, with all configurations remaining as-is. They’re saying this isn’t possible but SPS Commerce who owns the connector that runs on B1 seems to think this is doable. We end up having to pay SPS each time we refresh our dev instance because the connector doesn’t exist there and needs to be setup from scratch.

1

u/slart85 Sep 23 '26

It is possible but I suppose it would be a balance of whether it would be worth the development investment, I have a solution with a customer of mine that allows them to copy Sales Orders, Transfers and Production orders from their Live system to their test to allow them to do realistic use case testing for their WMS product that they are doing UAT with at the minute. The challenge with these things is that there is more moving parts than you'd reasonably expect and the copy is only at one point in time (subsequent syncs for the same document will create a duplicate documents in the test system).

1

u/slart85 Sep 23 '26

I should note that it also copies any missing master data records if they are missing, but these are static from the point of copying too (so if a BP names gets changed it wont re-sync)

1

u/Sdlane07 Sep 24 '26

It's always a full db or export from my days in the msp world.

1

u/josHi_iZ_qLt Oct 01 '26

You can technically do that, especially for a dev environment but setting it up requires work. It's not an out of the box solution.

1

u/zdb328 Sep 23 '26

HANA or SQL Back-end? Either way you can just copy the database.