YOUR STORY PLAYS HERE
Home » Categories » Multiple Categories

How to perform a system database migration

 

 

ATTENTION:

DOING A DATABASE MIGRATION INCORRECTLY COULD POTENTIALLY DELETE AND REMOVE ALL OF THE RECORDS FOR YOUR SYSTEM

Description

When moving to a new system or adding new machines to a system, you may have to perform a database migration. The database holds all of your user information, system configuration data, show record data, and carousel data. BE SURE TO HAVE SUFFICIENT DATABASE BACKUPS STORED IN A SAFE PLACE BEFORE PERFORMING A DATABASE MIGRATION.

Process

1. Stop all Cablecast and Carousel services that are running on the machine you are updating.

2. Open Internet Information Services (IIS) Manager and stop the service.

3. Open SQL Server Management Studio Express. When the connect to server window opens, click connect.

4. Expand the Databases folder on the left and locate the Cablecast40, Carousel50, and Frontdoor50 database folders. Right click on the database you wish to replace and select delete. 

   

5. Be sure to check the "Close Existing Connections" box in the delete object screen.

 

6. When you have all the databases you are replacing deleted, right click on the main Databases folder and select Restore Database.

7. Choose From Device in the Restore Database screen then locate and add the database you are restoring.

8. Click the restore check box for the database you just added. In the "To database" dropdown menu, be sure to select the exact database you are restoring.

9. Select options. Then click the check box for "Overwrite the existing database." Also be sure that the file path for the new database matches the path of the database you are replacing.  Click OK

10. Repeat steps 5 thru 8 to migrate the remaining databases.

11. Restart your Cablecast and Carousel services and you are all done.

 

Additional Information

If you are replacing the current database with a database that is running an older version of software, you will need to run scripts to update fields and data.

1. In SQL Server Management Studio, Select File then open. Locate the scripts  under C: or D: > TRMS> Database > Scripts. Some Databases will require you to create first and then populate. Select the appropriate script and click Open.

2. When the script is loaded, make sure the correct database is selected that you want to perform the script on.

3. Execute the script by clicking the check mark at the top. SQL Server will prompt you when the script is finished.

4. Repeat for all the databases.

 

0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Cablecast Installer overwrites some CSS files
Viewed 1024 times since Tue, Feb 3, 2015
I get an error that "There is insufficient memory in resource pool "internal" to run this query."
Viewed 1546 times since Fri, Sep 11, 2015
Accessing Carousel Rendering Logs
Viewed 791 times since Wed, Jan 18, 2017
Cablecast 6.0.1 is Released
Viewed 1402 times since Fri, Oct 30, 2015
What features of Carousel require a Multicast enabled network?
Viewed 1246 times since Tue, Oct 4, 2016
Retranscoding a VOD file in Cablecast 5.2 and above
Viewed 1469 times since Mon, Sep 22, 2014
Custom Carousel Fonts
Viewed 691 times since Fri, Sep 1, 2017
Streaming in HD & Cable Provider in SD
Viewed 584 times since Tue, Sep 5, 2017
When accessing Frontdoor, I get an "HTTP Error 404.2 – Not Found" error
Viewed 2228 times since Mon, Mar 2, 2015