Daktronics

Show Control: How do I use the Nucleus Server Database utility to transfer or save a database?

Topic

  • How do I use the Nucleus Server Database Utility?
  • Where is the Venus 1500 v4 Database?
  • How do I backup my Venus 1500 v4 Database?
  • How do I backup my Display Studio Database?
  • How do I backup my Vanguard Database?
  • How do I restore my Venus 1500 v4 database to a clean or fresh database?
  • How do I restore my Display Studio database to a clean or fresh database?
  • How do I load a backed up database to a new or different computer?
  • How do I move the existing schedule and images from one PC to another?
  • How do I transfer the Database to a new computer?

Environment

  • Product: 
  • Components: Nucleus Server Database Utility, Display Studio Database, Venus 1500 v4 Database
  • Control System: Venus 1500 v4 Software, Display Studio - Show Control Software, Vanguard v4 Software

Steps

NOTE: Microsoft SQL server is not backwards compatible. Be sure to check Microsoft SQL versions on each computer; the computer the database is being transferred to must have equal to or greater than SQL versions than the computer the database is being transferred from. Ex. If original database is using SQL2014, it cannot be loaded to a computer using SQL2008 or SQL2005.

  1. Determine operating system and locate Nucleus Database Utility as shown below. To determine if Windows 32-bit or 64-bit, please refer to How do I tell what type of Windows Operating System my computer is running?
    • 32 Bit System: C:\Program Files\Daktronics\Nucleus Server\Database Utility\
    • 64 Bit System: C:\Program Files (x86)\Daktronics\Nucleus Server\Database Utility
  2. Double-click on Daktronics Database Utility.

Nucleus Server Database Utility

  • The Nucleus Server Database Utility is used by different Daktronics software platforms:
    • Venus 1500 v4 Software
    • Vanguard v4 Software
    • Show Control Software
  • The Nucleus Server Database Utility as shown above can be used in different scenarios:
    • Clear the database to the original install state.
    • Migrate a user's database from one computer to another.
    • Create an on-demand backup of the database for later use or for testing.

 

Performing a Clean Setup

This will clear out the entire database that is currently on the computer, and there is no reversing this step. You will receive a prompt: Do you want to save the existing database before proceeding with New Setup?

  1. Only click "Yes" if you need to save the current database and have not already done so.
  2. Only click "No" if you want to clear current database.
  3. On the second prompt: Loading setup will overwrite your existing data, Continue? and click Yes

Performing a Save/Backup

This will save the database on the computer and allow it to be backed up or transferred to a different computer.
Note - this backup file contains all of the database information including presentation file and schedules. It is important that the file name not be change or renamed.

  1. Click the Save button.
  2. Save the backup file —browse to a desired location to save or backup the database such as Shared/Network Drive, Flash Drive and/or desktop, click Save. (the file will look like this: Backup.nucbak )

Performing a Load/Restore
  1. Click the Load Setup button.
  2. You will receive a prompt: Do you want to save the existing database before proceeding with Load Setup?
    • Only click "Yes" if you need to save the current database and have not already done so.
    • Only click "No" if you want to clear current database.
    • Typically, if this is a new computer, you can click No due to there is no database to save.
  3. On the second prompt: Loading setup will overwrite your existing data, Continue? and click Yes.
  4. Browse to the location where you saved the backup.nucbak file and double-click it, or highlight it and click Open.
  5. After loading is complete you will receive a message saying "Backup Loaded Successfully" and you can then open Venus 1500 V4.

 

Considerations

  1. If running a 32-bit version of  Windows, Nucleus Database Utility.exe is installed at [Program Files]\Daktronics\Nucleus Server\Database Utility. If running a 64-bit version of Windows, the Nucleus Database Utility will be in [Program Files (x86)]\Daktronics\Nucleus Server\Database Utility.
  2. The database backup includes all data files and content for M3 widget, it may take several minutes if the system has many files.

Reference Training Video on YouTube

  •  

    If unable to run the Nucleus Database Utility - 

    If unable to run the Nucleus Database Utility, a copy of the most recent backup can be obtained by following: How do I know if Venus 1500 v4 automatically backs up my database? , DD2433671 A copy of the database will need to be saved from the location mentioned. Once saved continue with step 1 under Performing a Load/Restore, above.

KB ID: DD1705994

DISCLAIMER: Use of this content may void the equipment warranty, please read the disclaimer prior to performing any service of the equipment.

DAKTRONICS DOES NOT PROMISE THAT THE CONTENT PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED ON AN "AS-IS" AND "AS-AVAILABLE" BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT, REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE PARTIES.

The above disclaimer applies to any property damage, equipment failure, liability, infringement, or personal injury claim arising out of or in any way related to your use or application of the content, whether such claim is for breach of contract, tort, negligence or any other cause of action.