We have a production SQL Server SDE Database called APA_GIS_PROD and a test environment called APA_GIS_UAT. The data is edited in ArcGIS 10.2.1 with ArcFM. Our production SQL Server is using SQL Server 2008 and the UAT using SQL Server 2014.
We want to refresh the UAT environment with the data from production but have just discovered that we can’t just copy the tables across using SQL Server tools as the database names need to stay the same.
Is there a way to copy all the data from our production environment into the test environment keeping the database names separate?