Backing up a Cityworks 23.X Production Database to a Test Environment. (On-Premises)
We just moved from Cityworks 15.6.8 to Cityworks 23.10 on both our production and test/training systems. We are an "On-Prem" shop. In the past I was able to successfully backup our production database and restore it to our test environment in order to refresh the data in the test system. Our production and test databases are hosted on the same database server. Does this method still work with CW23? If not, is anyone aware of any up to date documentation explaining how to do this? FYI - I did find one post on this site that covers the topic, but it's from 2022 and for 15.X.X versions.
Also, will backing up and restoring a database using this method wipe out customized Style profiles designed on the test system? I'm assuming it won't because I believe they are stored outside the database in JSON files. I'll backup the profiles regardless, but I just want to make sure.
Cheers, Dave
