Migration of sql server from 2005 to 2008 [Resolved]

Posted by Yrajudba under Sql Server on 7/28/2011 | Points: 10 | Views : 4947 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

HI,
my client is using sql server 2005 and having 150GB of data of production environment. Now he wants to migrate that database from 2005 to 2008, including the login's.
i am not aware of doing that migration process. can any one suggest.

Thanks
Raju

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Vforvijay on: 7/28/2011 [Member] Starter | Points: 50

0	hi..refer the link below........ http://www.packtpub.com/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps Yrajudba, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Lalji_mer on: 7/28/2011 [Member] Bronze | Points: 25

0	There are two ways to upgrade SQL Server 2005 to SQL Server 2008: * In-place upgrade uses the SQL Server 2008 setup program to directly upgrade a SQL Server 2005 instance to a SQL Server 2008 instance on the same machine. The older SQL Server 2005 instance is replaced, and the data is converted in-place by the new SQL Server 2008. * Side-by-side upgrade performs operations to copy all data and other database components from a SQL Server 2005 instance to a separate SQL Server 2008 instance, with both instances running on the same machine, or separate machines. Show this attachment doc file for more guide you will get from below link http://serverfault.com/questions/1841/how-to-migrate-from-sql-server-2005-to-2008 http://www.jphellemons.nl/post/Microsoft-SQL-Server-2005-to-2008-Upgrade-and-Migration.aspx Download source file LP MER Yrajudba, if this helps please login to Mark As Answer. \| Alert Moderator

There are two ways to upgrade SQL Server 2005 to SQL Server 2008:

* In-place upgrade uses the SQL Server 2008 setup program to directly upgrade a SQL Server 2005 instance to a SQL Server 2008 instance on the same machine. The older SQL Server 2005 instance is replaced, and the data is converted in-place by the new SQL Server 2008.
* Side-by-side upgrade performs operations to copy all data and other database components from a SQL Server 2005 instance to a separate SQL Server 2008 instance, with both instances running on the same machine, or separate machines.

Show this attachment doc file for more guide you will get from below link

http://serverfault.com/questions/1841/how-to-migrate-from-sql-server-2005-to-2008

http://www.jphellemons.nl/post/Microsoft-SQL-Server-2005-to-2008-Upgrade-and-Migration.aspx

Download source file

LP MER

Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts