- Back to Home »
- Infrastructure »
- Migrate from SQL Server 2000 to SQL Server 2014 Step by Step
Wednesday, April 13, 2016
To migrate SQL Server from version 2000 into version 2014, it will require three big steps:
- Backup/Restore from SQL Server 2000 into 2008
- Backup/Restore from SQL Server 2008 into 2014
- Detach/Delete unused database
Migrate SQL Server 2000 into 2014 |
On more detail process, will be shown how to migrate SQL Server from 2000 into version 2014, using SQL Server 2008 as interim. All processes are done using different virtual machine. Once the process completely done, the SQL Server 2008 can be removed safely.