Link to home
Start Free TrialLog in
Avatar of ExchangeKB
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
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ExchangeKB
ExchangeKB

ASKER

thanks, any input on the IIS side, moving from IIS 6 to 8 ?
IIS isn't my area but added the topic for you so the right Experts can advise about it.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial