Last post Aug 27, 2008 02:40 PM by JamesSAEP
Aug 27, 2008 12:42 PM|JamesSAEP|LINK
We are needing to deploy a new sql server and are not sure if we should use sql 2008 or not. We have existing databases that are on sql 2005 on a Windows 2003 box that will be moved over to the new server. If we deploy a Windows 2008 standard server with
SQL 2008 Standard on it, are we safe moving the old databases over or are there steps we need to take to migrate them?
Thanks for any advise.
Aug 27, 2008 12:49 PM|NecroxPy|LINK
I recommend to you SQL Server 2008... Why? You must see for your own.
It's totally compatible with other versions of SQL Server (7.0, 2000 and 2005). Better for 2005 migration.
Aug 27, 2008 01:06 PM|JamesSAEP|LINK
thanks for that response. can I use the SQL Server Management Studio Console that comes with 2008 to manage sql2005 servers?
Aug 27, 2008 02:27 PM|NecroxPy|LINK
Yes you can. Even you can install the sql server 2005 engine and open it inside SQL management studio 2008.
Aug 27, 2008 02:40 PM|JamesSAEP|LINK
Cool, thanks for the info - 2008 it is.