Wiki

Options

New Case Case Status
Log In

Wiki

Options

 
Knowledge Base Articles»KB000035 - Using the EtaPRO Da…
  • RSS Feed

Last modified on 12/5/2018 10:02 PM by User.

Tags:

KB000035 - Using the EtaPRO Data Packager

An EtaPRO configuration consists of several SQL databases which should be kept together as a package for manual backups or transfer to another server. An EtaPRO DataPackager utility is provided on the EtaPRO server hardware that will detach and and package the databases in *.zip files. It will also upzip the files containing the databases and reattach them to SQL Server.

Please note that this tool has been retired with EtaPRO 10.4 - SQL Server Management Studio should be used instead to attach and detach databases.

Compressing/Detaching EtaPRO Databases

The following steps describe how to make a manual backup of the EtaPRO configuration databases and how to detach the databases from SQL Server.

  1. Click the EtaPRO Service Manager icon in the Start | All Programs | EtaPRO 10 menu on the EtaPRO server hardware. The EtaPRO Service Manager dialog displays.

  1. Click the Stop All Services button.
  2. When all the services have stopped, close the EtaPRO Service Manager dialog.
  3. Select Start | All Programs | EtaPRO 10 | Tools | EtaPRO DataPackager to display the GP Data Packager dialog.

  1. Check each database in the Databases Attached list on the Compression tab.
  2. If the list of databases is not shown, click the Connect button to display the Connect to SQL Server dialog box. Change the Database Instance name to wherever the databases are hosted. A SQL Server username and password may be required.

  1. If you are doing a manual backup and you want the databases to be available after the backup is complete, DO NOT check the Leave Detached box.  if you check the Leave Detached box, the database files will not be re-attached after the backup and the databases will not be available for use by EtaPRO.
  2. Click the Compress button to make a backup of the databases and display the Save As dialog box.

  1. Select a location, enter a file name and click Save.
  2. You can now copy the *.zip file to an external backup location or to new hardware.
  3. If you are replacing the database files or moving them to another server, click the Detach box.
  4. The Database Connection dialog box displays indicating that the number of active connections. These connections have to be dropped before detaching the databases from SQL Server. Check the Drop Connections box for each databases with connections.

  1. Click Detach. A status message will display indicating which databases were successfully detached.

  1. Click Exit to close GP Data Packager dialog box.
IMPORTANT!  Restart all the EtaPRO services using the EtaPRO Service Manager unless you are replacing the databases on the existing server or moving the databases to new hardware.

 Decompressing/Attaching EtaPRO Databases

  1. Select Start | All Programs | EtaPRO 10 | Tools | EtaPRO DataPackager to display the GP Data Packager dialog.
  2. To attach the EtaPRO databases to SQL Server, click the Decompression tab.

  1. Click the Browse button to locate the *.zip file or *.mdf database files you wish to attach.

  1. The Open dialog box displays. Select the files you wish to attach and then click Open.

  1. The list of databases displays in the Selected Files field.

  1. Click the Attach button and then click Exit to close GP Data Packager dialog box.
  2. Click the EtaPRO Service Manager icon in the Start | All Programs | EtaPRO 10 menu on the EtaPRO server hardware. The EtaPRO Service Manager dialog displays.

  1. Click the Configuration Setting button and select the database for Database tabs on the Configuration Settings dialog.

  1. Click OK to return to the EtaPRO Service Manager dialog and start all the EtaPRO services.
  2. When all the services have started, close the EtaPRO Service Manager dialog.
For additional assistance with this procedure or to report an error, please contact EtaPRO Support at etaprosupport@gpstrategies.com or 716-799-1077.