I have a few questions regarding transferring to another internal server and if you could help me with any of these questions help is appreciated.
We have currently two servers running on SQL Server 2016, one server has the DEV and ACC environments and the second server has our PROD Environment (TimeXtender 18.104.22.168).
The environments were installed by a supplier but their external employee left, so we want to try and install this on our own (with snapshots/backups in case something goes wrong).
We want to try and move the DEV/ACC environment to a new server which has the same TimeXtender version but SQL Server 2019. For this move I have 3 questions:
- Can I just export and import the project from old server to my new server and load the data again into a new SQL database?
- How can I set up my environments in such a way that my DEV → ACC → PROD traject isn’t changed. I could not find those settings and had trouble finding them on the legacy page. As the DEV/ACC environments are on the same server and the PROD environment is on another server.
- Is it harmful to have a DEV/ACC environment on a higher SQL Version as the PROD environment? We would like to upgrade everything to 2019, but we want to test with our DEV/ACC environments to not hurt our production and the business.
If you can help me with any of this any help would be appreciated. Either by linking me to the correct page or any useful tips or remarks I should have.
Best answer by Christian HauggaardView original