SQLTeam.com | Weblogs | Forums

Steps to migrate the SQL 2005 reporting databases to SQL 2008 R2


#1

Help needed:
Steps to migrate the SQL 2005 reporting databases to SQL 2008 R2. Please let me know the steps i need to consider during the migration and upgrade.This is not a in place upgrade.Moving to the new server.

Thank You.


#2

migrating to 2008 r2


#3

There are different methods to migrate SQL database from one Server to another like by generating script, Copy database wizard etc. Here are the step-by-step process to migrate SQL Server 2005 database to SQL 2008R2 database:
https://www.cybrary.it/0p3n/best-way-copy-sql-server-database-one-server-another/