Wonderware Galaxy Database Manager

User's Guide
© 2017 Schneider Electric Software, LLC. All rights reserved.
No part of this documentation shall be reproduced, stored in a ret rieval system, or transmitted by any
means, electronic, mechanical, photocopying, rec ording, or otherwise, without the prior written
permission of Schneider Electric Soft ware, LLC. No liability is assumed with respect to the use of the
information contained herein.
Although precaution has been taken in the preparation of this documentation, Schneider Electric
Software, LLC assumes no responsibility for errors or omissions. The information in this documentation
is subject to change without notice and does not represent a commitment on the part of Schneider
Electric Software, LLC. The software described in this documentation is furnished under a license
agreement. This software may be used or copied only in accordance wit h the terms of such license
agreement.
ArchestrA, A vantis, DYNS IM, eDNA, EYESIM, Foxboro, Foxboro E vo, I/A S eries, InBatch, InduS oft,
InStep, IntelaTrac, InTouch, PIPEPHASE, PRiSM, PRO/ II, PROVIS ION, ROMeo, Schneider Electric,
SIM4ME, SimCentral, SimSci, Skelta, SmartGlance, Spiral Soft ware, VIS UAL FLA RE, WindowMaker,
WindowViewer, and Wonderware are trademarks of Schneider Electric SE, its subsidiaries, and
affiliated companies. An extensive listing of Schneider Electric Soft ware, LLC trademarks can be found
at: http://software.schneider-electric.com/legal/trademarks/. All other brands may be trademarks of
their respective owners.
Schneider Electric Soft ware, LLC
26561 Rancho Park way South
Lake Forest, CA 92630 U.S.A.
(949) 727-3200
http://software.schneider-electric.com/
Publication date: 3/7/2017
Contact Us
Contact Schneider Electric Software Technical Support
Avanti s Technical Support
Listing of regional and local country contacts: http://software.schneider -electric.com/support/avantis/
Technical support: http://softwares upport.schneider-electric.com/
For A vantis.PRO, A vantis Approvals, Avantis.DSS, and Condition Manager:
 Email: support.pro@avantis.net
 Phone (8:30 a.m. to 5:00 p.m. Monday to Friday, Eastern Time):
o Toll-Free U.S. and Canada: 1-888-262-7111
o Toll-Free EMEA: 1-800-4670-6466
o Direct dial: 1-905-632-0635
For A vantis. XA:
 Email: support.xa@avantis.net
 Phone (8:30 a.m. to 5:00 p.m. Monday to Friday, Eastern Time):
o Toll-Free U.S. and Canada: 1-800-991-8000
o Toll-Free EMEA: 1-800-4670-6466
o Direct dial: 1-905-632-4122
SimSci Technical Support
Listing of regional and local country contacts: http://software.schneider -electric.com/support/simsci/
Technical support: http://softwares upport.schneider-electric.com/
 Phone (USA 8:00 a.m. to 5:00 p.m. Central Time)
o Toll-Free U.S. and Canada: 1-800-746-7241
 Email U.S. and Canada: support.simsci@schneider-electric.com
Wonderware Technical Support
Listing of regional and local country contacts: https://www.wonderware.com/contact/contact -support/
Technical support: http://softwaresupport.schneider-electric.com/
 Priority email for Customer FIRS T Members: custfirstsupport@wonderware.com
 Email for customers without a support agreement: wwsupport@wonderware.com
 Phone
o Toll-Free North America and Latin Americ a: 1-800-966-3371
o Direct dial: 1-949-639-8500
InStep Technical Support
Cont act page: http://www.instepsoftware.com/contact-us
Technical support: https://support.instepsoft ware.com/
 Email: instepsupport@schneider-electric.com
 Phone (USA 8:00 a.m. to 5:00 p.m. Central Time)
o 1-312-894-7870
Schneider Electric – Smart Water Software Technical Support
 Help desk email: DK-HSO-Support@schneider-electric.com
 Help desk telephone hotline: +45 88 30 20 77 (09:00 to 16:00 Monday to Thurs day, Friday 09:00 to
15:00, Central European Time)
Contact Schneider Electric Software Learning Services
Cont act Software Learning Services for assistance regarding classes, schedule, offerings, frequently
asked questions, tuition, policies, and more.
 Email: software.training@schneider-electric.com
 Toll-Free U.S. and Canada: 1-866-998-7246
 Direct: 1-949-639-8508
 Fax: 1-949-639-1847
 Wonderware Galaxy Database Manager User's Guide

Contents
Chapter 1 Overview ............................................................................................................... 7
System Management Console ................................................................................................... 7
Starting the Galaxy Database Manager ...................................................................................... 7
Navigating in the Galaxy Manager.............................................................................................. 8
Cons ole Tree ...................................................................................................................... 8
Details Pane ....................................................................................................................... 8

Chapter 2 Using the Galaxy Database Manager .............................................................. 9

Backing Up a Galaxy ................................................................................................................. 9
Restoring a Galaxy.................................................................................................................. 10
Determining the Galaxy Database Manager Version .................................................................. 10

5
 Wonderware Galaxy Database Manager User's Guide

C HAPTER 1
Overview
The Galaxy Database Manager is an ArchestrA utility you can use to manage your Galaxies. Use it to
back up your Galaxies so that if a Galaxy becomes corrupted, you can restore the Galaxy. You can
also use a backup to reproduce a Galaxy on another computer
The Galaxy Database Manager is automatically installed on every Galaxy Repository node.

In This Chapter
System Management Console ......................................................................................................... 7
Starting the Galaxy Database Manager ............................................................................................ 7
Navigating in the Galaxy Manager ................................................................................................... 8

System Management Console

The Galaxy Database Manager is part of the A rchestrA System Management Console (SMC) suite of
utilities you can use to manage the Arc hestrA environment. The SMC is a snap-in to the Microsoft
Management Console (MMC).
The MMC and each SMC utility provides its own doc umentation. For more information, click Help on
the Action menu. The first Help book shown (Microsoft Management Cons ole) provides information
about the MMC utility in general. Each SMC utility is then represented by a Help book below the MMC
book.
This document describes the functionality and user int erface of the Galaxy Database Manager. It
describes common features of the MMC only if required to explain Galaxy Dat abas e Manager
functionality.

Note: Aspects of the Galaxy Database Manager user interfac e may look different when installed on
different versions of Microsoft Windows. Also, the version of MMC installed on your computer affects
the content and behavior of the user interface.

Starting the Galaxy Database Manager

To start the Galaxy Database Manager utility
1. Click Start.
2. Click Programs.
3. Select Wonderware.
4. Select System Management Console.
The Galaxy Database Manager is listed in the SMC’s console tree hierarchy.

7
Wonderware Galaxy Database Manager User's Guide Overview

Note: You must have Administrator privileges on the Galaxy Repository computer to use the Galaxy
Database Manager. You may need additional privileges if security for the Galaxy database is set up
through Microsoft SQL Server. See SQL Server documentation for further instructions.

This Galaxy Database Manager utility provides a view of all Galaxies in your Galaxy Repository. Select
the Galaxy Databas e Manager in the SMC hierarc hy to see a list of Galaxies in the details pane of the
MMC.

Navigating in the Galaxy Manager

From the SMC console, you can access drop -down menus, context menus, and dialog boxes for
backing up and restoring your Galaxies.
The contents of the title bar, menu bar, toolbar, and status bar are dynamic depending on whi ch item is
selected in the console tree or details pane. The contents of the details pane also change as you select
different items in the console tree hierarchy.
The title bar shows the item selected in the console tree hierarchy. The status bar either shows the
condition, if any, of the item selected in the console tree or provides a brief description of a highlighted
command in a menu.

Console Tree
The console tree is a hierarchical structure beginning at the ArchestrA System Management Console
(SMC) root. All SMC utilities are shown next in the hierarchy, including the Galaxy Database Manager.
All Galaxies in your Galaxy Repository are shown on the next level of the hierarchy.
The contents of the details pane change as you select items in the console tree.

Details Pane
The details pane is composed of two main elements:
 Column headings: when Galaxy Database Manager is selected in the console tree, two columns
are shown, Node and Galaxy. The Node column identifies which node a Galaxy resides on. The
Galaxy column displays the Galaxy’s name. Use this information when backing up and restoring
Galaxies.
 Data window: shows Galaxy data.
The contents of the details pane change as you select items in the console tree. See MMC Help for
information about managing column headings.

8
 Wonderware Galaxy Database Manager User's Guide

C HAPTER 2
Using the Galaxy Database Manager
You use the Galaxy Database Manager to back up and restore a Galaxy.
Backing up a Galaxy creates a single backup file (.cab extension) containing all the files, configuration
data, and object deployment states required to recreate the Galaxy in an empty Galaxy Repository.
During the backup, no write operations are allowed to the Galaxy Repository. If write activity is
occurring, you should back up at a later time.
Restoring a Galaxy uses the backup file to overwrite an existing Galaxy or to creat e the backed up
Galaxy in a different Galaxy Repository. The restore process prompts you for confirmation before a
Galaxy is overwritten.
All objects should be undeployed before begining to restore a Galaxy. During the restore, no clients
can use the Galaxy Repository. If these conditions are not acceptable, you should restore at a later
time.

In This Chapter
Backing Up a Galaxy ...................................................................................................................... 9
Restoring a Galaxy ....................................................................................................................... 10
Determining the Galaxy Database Manager Version ....................................................................... 10

Backing Up a Galaxy
The backup function of the Galaxy Database Manager archives all files and configuration data required
to recreate the selected Galaxy in an empty Galaxy Repository.
To back up a Galaxy
1. In the console tree of the ArchestrA System Managem ent Console, select Galaxy Database
Manager. The details pane shows all Galaxies and the nodes they reside on.
2. In the details pane, select the Galaxy you want to back up.
3. On the Action menu, click Backup.
4. Read the warning message.

5. Click Yes.
6. In the Save In dialog box, enter the path and file name (.cab extension) of the backup file you want
to create. Use the browse button to find a file or a location.
7. Click Save. To terminate the backup, click Cancel.
8. When the backup function is finished, click Close.

9
Wonderware Galaxy Database Manager User's Guide Using the Galaxy Database Manager

Restoring a Galaxy
You can choose a backup file to overwrite an existing, corrupted Galaxy or to reproduc e a Galaxy in
another Galaxy Repository.
If you are reproducing a new Galaxy on another Galaxy Repository with the restore function, first use
the ArchestrA IDE to create the new Galaxy in the target Galaxy Repository. The names of the new
Galaxy you creat e in the IDE and the backed up Galaxy you use in the restore proc ess must be the
same. See the IDE documentation for more information about creating Galaxies.
To restore a corrupted Galaxy or to reproduce a Galaxy in another Galaxy Repository
1. In the console tree of the System Management Console, click Galaxy Database Manager. The
details pane shows all Galaxies and the nodes they reside on.
2. In the details pane, select the corrupted Galaxy you want to restore or the name of the Galaxy you
want to reproduce.
3. On the Action menu, click Restore.
4. Read the warning messages. Click Ye s to continue restoring and No to terminate the restore
function.

5. Enter the path and file name (.cab extension) of the backup file you want to use. Either type the
path and file name or us e the brows e button to explore for a file or location. The default path is the
last folder used for a backup or restore.

6. To continue, click Restore. If you have an active client connected to the Galaxy Repository, a
message appears. You are required to quit those client programs before restore can continue. To
terminat e the restore function, click Cancel.
7. When the restore function is finished, click OK.

Determining the Galaxy Database Manager Version

You can view the version, copyright and other information about the utility.
To view Galaxy Database Manager information
1. Select Galaxy Database Manager in the ArchestrA System Management Console hierarchy.
2. On the Action menu, click Galaxy Database Manager.

3. Click OK when you are done viewing the information.

10