Hi All,

Currently we are working under 2005 sql server platform, and now we need to migrate our DB server to sql server 2008 / 2005 due to hardware issues. Hence please advise us to do the same.. kindly let us know, which platform is more simple to migrate and is there any migration tool (built in or third party ) for doing the same / is it possible to migrate all the databases in a couple of steps?

Your help would be much appreciated!

Thanks in advance,
Goicontini

You can simply back up the databases on the SQL 2005 box, and restore them on the SQL 2008 box. You will need to recreate any login information, and/or SQL Agent jobs, however. As with anything, copious testing should be required.

Review the output from Upgrade Advisor (it is part of SQL2K8 Feature Pack), and then go from there.

A quick question to MCrowley, is it possible to do all the database backup / restore in a single step? or do I need to backup each database by one by one and restore it on new server by one by one? please advise

You will need to back up the databases one by one. Some tools allow for backing up an entire server to tape (Legato, Symantec, etc.), but in the background, these things are also doing individual backups.