If you are working with Carousel to move from Carousel 7 to Carousel Cloud, you may be asked for some specific system information about your current system. We have put some SQL queries together that you can run against on your Carousel Database to make getting that information easier! If needed, please contact your SQL database admin for assistance.
These scripts can be run using SQL Management Studio on a Carousel 7 SQL Database Server to gather information about your current system in preparation for a Cloud Conversion. The scripts only ‘read’ the data from SQL, no information is being edited or changed.
Players.sql - Pulls the Player Name, IP Address, Current Channel, and Version (implies type)
Channels and Zones List.sql - Pulls the Channel(s) into one column, Zones for the Channel(s) into the next column, and Full Alert(s) for the Channel(s) into the third column
Zone Tags.sql - Pulls all the Zone Tags in one column and any associated Zones into the next column
Linked Bulletins.sql - Pulls all zones that contain a linked bulletin
Download all four scripts onto the desktop of your Carousel 7 server, and double click one to open SQL Management Studio. If accessing the server remotely, you may be prompted to click Connect on two pop-ups. Once you see the script open, select the heading of the script window and then click the Execute button. After the script has run, another heading will open below displaying the results. Click ‘Results’ so that the section is highlighted and then File > Save Results As… to save as a Text (Tab delimited .txt) file. Preferably name the .txt file the same as the SQL script that you just ran. Close the script by clicking the x on the heading of the script window, and minimize SQL Management Studio or navigate back to the desktop and follow the same procedure for the other two scripts. Note: each script can only be run one time without closing the heading window and re-opening.