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.
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.
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/