November 27, 2011 at 9:53 pm
hi,
i m going to migrate from sql server 2005 to sql server 2008 (SP3)
what is prerequisite?
please help me ...
November 27, 2011 at 11:58 pm
Planning a SQL Server Installation
http://msdn.microsoft.com/en-us/library/bb500442.aspx
How to: Upgrade to SQL Server 2008 R2 (Setup)
November 28, 2011 at 12:16 am
thanks dev for your valuable inputs .
but i have already installed sql server 2008 with service pack 3 in anther windows server 2008.
now i want to transfer all database and login and so on..
as it is on old server..
November 28, 2011 at 12:26 am
Dhirju (11/28/2011)
thanks dev for your valuable inputs .but i have already installed sql server 2008 with service pack 3 in anther windows server 2008.
now i want to transfer all database and login and so on..
as it is on old server..
You may opt for backup / restore for migrating the data.
You may optionally go for SSIS.
Please don't forget to script out Logins / Jobs etc.
November 28, 2011 at 2:38 am
Thanks 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply