Live database sync to test database for daily testing and trainings

Question

I am looking for solutions to copy our sage x3 production folder either nightly or live sync to another folder in the database. 
 This backup/synced database should be accessible through sage as well for testing, always with up to date information (nightly) 
 
 Currently, I have to have everyone off the Sage Server to be able to achieve this. Being that we run 24/7, the chance to do this is extremely rare. This &ldquo;sync&rdquo; project would allow us to run every day nonstop in our live PROD folder, while having a secondary synced database &rdquo;BK-PROD&rdquo; where we can test functions and data changes. 
 
 Any changes to the synced database "BK-PROD" would be overwritten by the new nightly &ldquo;re-sync&rdquo; 
 
 Any idea if this is possible?

jcarraway · Answer

I had to come up with something similar for our company after getting tired of spending late nights doing folder copy processes to spin up an active copy of our Production endpoint for training or testing. This is what I did. 
 Each night a sage scheduled task DOSSVG creates a current copy of the SVG folder in the Production endpoint, then (after it is complete) on our host server we run a nightly windows scheduled task of a robocopy batch script that syncs the current production folder and x3_pub folder (along with SVG and TRT folder for long-term backup) and timestamps. After the copy the SVG folder in the parent folder is cleared in preparation for the next nights backup. A copy of my script is below: 
 @echo off echo wscript.echo year(date) ^& right(100 + month(date),2) ^& right(100+day(date),2) > "%temp%\dateparts.vbs" for /f "tokens=1 delims=" %%a in ('cscript //nologo "%temp%\dateparts.vbs"') do set yyyymmdd=%%a echo Today is %yyyymmdd% robocopy D:\Sage\X3\folders\PROD\SVG D:\Sage\X3\folders\archive\SVG-%yyyymmdd% /S robocopy D:\Sage\X3\folders\PROD\TRT D:\Sage\X3\folders\archive\TRT-%yyyymmdd% /S robocopy D:\Sage\X3\folders\PROD D:\Sage\X3\folders\archive\PROD-copy /MIR robocopy D:\Sage\X3\folders\X3_PUB\PROD D:\Sage\X3\folders\archive\PRODX3PUB-copy /MIR del /s /q "D:\Sage\X3\folders\PROD\SVG\*.*" 
 
 Once this is done, at any time I can just copy the endpoint folder and X3_PUB folder to their respective directory and rename them whatever I need to for the new endpoint, and run a folder import in Safe X3 console. I can do this while users are in Sage working as it does not interfere with the live production endpoint they are in. 
 All that is required after is that you point the endpoint in sage to the new folder. 
 If you need to import an already existing folder name you'll need to clear both the folder on the server and, in SQL, the tables, views, programmability>sequences, security>users, and security>schemas associated with the endpoint folder being replaced. (If you don't do this it will be trying to write tables over tables, etc on import.) 
 
 Now, if you're talking about completely syncing to a live secondary endpoint, I am unsure if overriding the current secondary folder with a renamed copy of your primary folder would do what you want, as the Safe X3 console loads the data from the endpoint folder into sql, etc. 
 At the very least this will greatly cut down on the amount of time it takes to refresh your secondary endpoint, we can spin up a copy in <1hr at any time of day. 
 
 Note: Make sure there are no transactions or batch tasks scheduled during the time DOSSVG runs at night.

Sage X3

Live database sync to test database for daily testing and trainings

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING