Copy 2012 MsSQL Server Database to 2017 MsSQL Server

by Glenn Sampson   Last Updated July 11, 2019 22:06 PM - source

I was wondering if this was possible as currently my task is failing.

I have a production database on a enterprise MsSQL Server 2012 this has been copied to a enterprise MsSQL 2012 on a staging server successfully.

My last step is to now copy this to my development environment.

This environment is a developer MsSQL Sever 2017.

I step through the setup step to copy the database to the dev environment and it starts running. It successfully connects to both using SQL Admin, then starts to copy the files (you can see them appear in the path at the desired server), fails, deletes the files and doesn’t create a log file.

Any thoughts/work arounds please

Related Questions

Data migration from SQL Server to MongoDb

Updated July 27, 2015 17:02 PM

migrating from Postgres to MonetDB

Updated March 26, 2015 09:02 AM