Hi Gaurav,
Through the UI you could do a data extract sequence to get the data out and reload it. But the best way is what you mentioned and probably have already done, just do a full Application backup with Data. Since you're on-prem and the year is 2023 and space is probably not an issue as it relates to cost, just do the full application backup and date-time stamp the application copy. Say Production Backup 2023June. Eventually you'll have a few date-time stamped back ups and using that backup naming methodology, you can delete old back ups and just keep the latest 2 or 3.
It is simpler to do that. Then, migrate application artifacts as needed such as your specific BR's, Reports, other code to your backup application. That will be easier than reloading data.
OneStream probably has a way to do the data (just the data) migration/backup using SQL Server DB magic, if so please post that here!
Regards,
Mike G
