How to Migrate SAV Reporting Server Database to MS SQL from MSDE

Article:HOWTO32434  |  Created: 2010-09-29  |  Updated: 2010-10-09  |  Article URL http://www.symantec.com/docs/HOWTO32434
Article Type
How To



  • SAV Reporting Server is Currently installed with MSDE and you want it to migrate to a MS SQL database.


Solution:

  • Backup the database using 'osql' utility.
  1. Connect to the MSDE instance using the command 'osql -U sa'(If you are not running the OSQL utility on the computer that is hosting MSDE, you can still run OSQL from another computer, and then use the -U command-line switch to specify the server in the connection command. For example: osql -s servername -U sa)
  2. To perform a full backup run the command 'BACKUP DATABASE Reporting TO DISK = 'C:\MSDE\Backup\Reporting.bak' and enter. Then type 'go' and press enter again.
  3. Move the back up to a safe location.
  4. Use control panel to uninstall the reporting server including the database.
  5. Uninstall the MSDE instance using control panel.
  6. Install MS SQL(Supported Versions 2000 SP4, 2005 SP2) on the reporting server or install appropriate SQL client tools if you want to use an existing database server.
  • Restore the database.
  1. To restore the database using 'osql' connect to the database by running the command 'osql -U sa'(If you are not running the OSQL utility on the computer that is hosting SQL, you can still run OSQL from another computer, and then use the -U command-line switch to specify the server in the connection command. For example: osql -s servername -U sa)
  2. Run the restore command 'RESTORE DATABASE Reporting FROM DISK = 'c:\path\to\backupfile.bak' press enter and type 'go' then enter again.
  3. To restore the database using SQL Management Studio connect to the database using 'sa' credentials.
  4. Right click on 'Databases' and select 'Tasks'.
  5. Select 'Restore' from tasks option.
  6. After successfull completion of the restore process the reporting serve can be re-installed.
  7. Use the appropriate SAV/SCS Cd to install back the reporting server.
  8. Provide correct server/Instance name and 'sa' credentials to finsih the configuration and installation.
  9. Configure reporting server options accordingly post successfull re-installation.



Article URL http://www.symantec.com/docs/HOWTO32434


Terms of use for this information are found in Legal Notices