Skip to main content
Participating Frequently
Oct 2, 2025 2:08 PM UTC

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

    5 replies

    Known Participant
    Oct 2, 2025 4:12 PM UTC

    I'm on 23.10 on-prem as well, and I stood up a new test environment a few weeks ago. It seemed straighforward, but like you suspect STYLE profiles are not included in the database. You will need to be export and imported them separately. When you have a fresh install of CW 23.10 on your test machine, part of the normal setup steps of the core configuration is to point to the database connection you want to use -- you'll just put in the connection information for your test db/backup instead of the production db. You can even have multiple connection strings saved and 'activate' the one you want to use. I believe you will have seen these same menus from when you performed your upgrade steps, minus the database migration stuff you had to do.

     

    "f825f1d3-2047-4b01-ba2a-0f0662d5c3cc""5b3214aa-50bf-4c02-9164-abb0b843d817"?"2038594a-2e7f-475c-b956-167a233eba20" 

    Translate
    Participating Frequently
    Oct 2, 2025 4:12 PM UTC

    I'm on 23.10 on-prem as well, and I stood up a new test environment a few weeks ago. It seemed straighforward, but like you suspect STYLE profiles are not included in the database. You will need to be export and imported them separately. When you have a fresh install of CW 23.10 on your test machine, part of the normal setup steps of the core configuration is to point to the database connection you want to use -- you'll just put in the connection information for your test db/backup instead of the production db. You can even have multiple connection strings saved and 'activate' the one you want to use. I believe you will have seen these same menus from when you performed your upgrade steps, minus the database migration stuff you had to do.

     

    "f825f1d3-2047-4b01-ba2a-0f0662d5c3cc""5b3214aa-50bf-4c02-9164-abb0b843d817"?"2038594a-2e7f-475c-b956-167a233eba20" 

    Hey Calvin,

     

    Thank you for taking the time to reply!

     

    This is great information. Setting up a new database instance with current production data and configuring it as a second database option for the test system appears to be the way to go. That way I can go back to the original test db if something goes wrong.

     

    Cheers, Dave

    Translate
    Participating Frequently
    Oct 2, 2025 4:12 PM UTC

    Hey Calvin,

     

    Thank you for taking the time to reply!

     

    This is great information. Setting up a new database instance with current production data and configuring it as a second database option for the test system appears to be the way to go. That way I can go back to the original test db if something goes wrong.

     

    Cheers, Dave

    @david long?  I just did a backup and restore from Prod to Dev and it is basically the same as 15.8.X just remember to run the sql command exec sp_change_users_login 'Update_one','azteca','azteca'; and change your settings to point to the DEV and you should be good to go

    Translate
    Participating Frequently
    Oct 2, 2025 4:12 PM UTC

    Success! Thank You @calvin harmin? and @Alan Marsh?.  

    Translate
    Participating Frequently
    Oct 2, 2025 4:12 PM UTC

    Great to hear.

    Translate