I have 3 databases that I want to move from SQL Server 2000 to another box which has SQL Server 2008. What is the best way to do this?
I was thinking making a backup of each database on SQL Server 2000 and then going to SQL Server 2008 and restoring those files. Is that possible?
Thank you in advance!