SQL Server Migration 2000 - 2008
Posted on 2014-09-18
I've just been presented with a Microsoft SQL Server 2000 which has a few smallish databases on it that I need to move to SQL 2008 at least. I don't want to perform an in place upgrade on that server as it's old and given it's the production machine it would be too stressful, I do have a spare server where I could install SQL2000, copy the production data to and perform an in place upgrade on that.
What I was really hoping for was for any advice on best practice from someone that has done something similar, I am of course concerned about migrating the DTS jobs as well.