ExchangeKB
asked on
Migrate SQL 2005 DB to SQL 2016
I am looking into a migration of an environment which was recently aqcquired from a previous IT, havent had the best of handovers. The business has 2003 R2 server running SQl 2005 Express , the business has now got a new Windows Server 2012, I have installed SQL Server 2016 SP1 express edition.
There is one database on the 2005 which was built inhouse and has a IIS6 front end. I am trying to find the best way forward to get the database from 2005 onto the new 2016. I believe i need to backup and import the DB and also do the same for the IIS front end.
-Please assist in providing a migration plan, how to preform this, high level/low level
-Any issues in migrating from 2005 to 2016, should i opt for SQL 2014
There is one database on the 2005 which was built inhouse and has a IIS6 front end. I am trying to find the best way forward to get the database from 2005 onto the new 2016. I believe i need to backup and import the DB and also do the same for the IIS front end.
-Please assist in providing a migration plan, how to preform this, high level/low level
-Any issues in migrating from 2005 to 2016, should i opt for SQL 2014
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
IIS isn't my area but added the topic for you so the right Experts can advise about it.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER