How do I use the Nucleus Server Database utility?

Question

  • 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 restore my Venus 1500 v4 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 Family: Video Software and Controllers
  • Product: Venus 1500 v4 Software, Show Control Software, Vanguard v4 Software​
  • Components: Nucleus Server Database Utility, Venus 1500 v4 Database
  • Control System:

Answer/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, DD2532255?
    • 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.

  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-Restoring is a permanent change and will overwrite any existing data.

  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.
Additional Notes:

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
  •  

 

Work Around

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 Preforming a Load/Restore, above.

KB ID: DD1705994


Fill out my online form.
DISCLAIMER: Use of this content may void the equipment warranty, please read this DISCLAIMER prior to performing any service of the equipment.