How To Migrate the Argos environment to a new server

The Argos 7 Database is built on the robust foundation of Microsoft SQL Server 2012 technology.  The convenience and flexibility of design allows for recommended Microsoft migration procedures to be utilized. This article describes the process of moving the Argos 7 Database using Microsoft SQL Server Management Studio Express (SSMSE), a free tool provided by Microsoft.

Warning

Incorrect migration of the Argos 7 database can cause serious problems that may lead to loss of data. Sepialine cannot guarantee that problems resulting from an incorrect migration and/or conditions specific to your database can be solved. Furthermore, Sepialine service contracts DO NOT include directly-assisted database migrations.  Sepialine provides Argos database migration as a separate service.  Please contact the Sepialine sales department for more information about Sepialine-assisted migration support services.

INSTRUCTIONS

The following Argos Migration documentation is designed for information technology professionals planning to move their own Argos database.  It is strongly recommended that the individual(s) performing the upgrade be familiar with Microsoft SQL database technology and administration.  In addition, a Windows Domain account that is a member of the Local Machine and/or Domain Administrators group is required.

For the content of these instructions, the source server will be referred to as Server A and the new host server will be called Server B.  The instructions specifically cover the migration between machines running the Sepialine install of SQL 2012 Express.

Phase 1 - Install Argos 7 on Server B

  1. Apply all Microsoft recommended Windows service packs and critical updates from Windows Update 
  2. Download the latest release of Argos 7 from http://sepialine.com/argos/download.html
  3. Run Argos7Install.exe to unpack the latest version of Argos
  4. Follow the standard installation steps to install all desired components on the new server
  5. Open Argos Manager to verify that the installation was successful. Note that any changes you make in the Manager will be erased.
  6. Open the Communication Service health page on Server B (http://SERVERB:7080/cs/health) to verify that the installation was successful. The Last update result for the Billing coordinator component should read Success after 5 seconds.
  7. Download and install SQL Server Management Studio Express on Server B

Phase 2 - Backup Database on Server A

The Argos 7 database from your old server can be backed up using SSMSE. Alternately, you can use standard SQL statements to create a backup through SQLCMD, however, this method is not covered in this article.

  1. Open SSMSE on your new server. At the connection prompt, use the following settings:
    • Server type: Database Engine
    • Server name \ db instance name: SERVERA\ARGOS                                                                                (replace ServerA with the name of your old server;                                                                               the default instance name for Argos 7 is ARGOS.)
    • Authentication: SQL Server Authentication
    • Login: sa
    • Password: s3p14_lin3
  2. Click Connect                                                                                                                                                                                                                                             
  3. Expand Databases to display the Argos7 database                                                                                                                                                                          
  4. Right-click on the Argos7 database, click Tasks > Back UP                                                                                                                     
  5. Make a note of the Destination settings. Argos 7 creates a nightly backup of your SQL database, typically in one of the following locations:
    • Server 2012/2008, Windows 7/8/10: C:\ProgramData\Sepialine\Argos7\Backup\Argos.bak
    • Server 2003/XP:                                                                                                                       C:\Documents and Settings\All Users\Application Data\Sepialine\Argos7\Backup\Argos.bak                                                                                                                                  
  6. Click OK to perform another backup to the same location
     
  7. The backup of database 'Argos7' completed successfully, click OK
     
  8. Log on to Server A and copy Argos.bak to a folder on Server B.                                                                                                                                      

Phase 3 - Restore Database on Server B

Remove the empty Argos 7 database installed on Server B during Phase 2:

  1. Open SSMSE on your new server. At the connection prompt, use the following settings:
    • Server type: Database Engine
    • Server name \ db instance name: SERVERA\ARGOS                                                                                (replace ServerA with the name of your old server;                                                                               the default instance name for Argos 7 is ARGOS.)
    • Authentication: SQL Server Authentication
    • Login: sa
    • Password: s3p14_lin3
  2. Click Connect                                                                                                                                                                                                        
  3. Expand Databases to display the Argos7 database                                                                                                                                                                                                    
  4. Right-click Argos7 and choose Delete
                                                                                                                                                                             
  5. The Delete Object screen will appear. Check the Close existing connections box and click OK.
                                                                                                                         
  6. Your Argos7 database will disappear from SSMSE
                                                                                                                                                                         
  7. Right-click Databases and choose Restore Database
                                                                                                                                                                           
  8. In the Restore Database window, select Device and click the ellipse button.                                                                                                                      
  9. In the Select backup devices window, click the Add button                                                                                                                                             
  10. In the Locate Backup File window, browse to the location where the backup file is located, highlight the .bak file and click OK.
                                                                                                                         
  11. In the Select backup devices window, click OK
                                                                                                               
  12. In the Restore Database window, click OK.                                                                                                                                                                     
  13. Database 'Argos7' restored successfully, click OK.
                                                                                                                                                                   
  14. Close SSMS. Open Argos Manager, click View > Settings.                                                                                                                                                                                                       
  15. In the Argos Manager Settings window, click the Database Connection... button.                                                                                                                                                                                                                               
  16. Verify that the Server field contains the new server and instance name. Click the Test connection... link.
                                                                                                                                                     
  17. Connected successfully, click OK.                                                                                                                                                                                                                                                                   
  18. Click Save                                                                                                                                                                                                                                                     

Upgrading from a previous version

If you upgraded to a newer version of Argos while migrating, you'll receive the following error when you launch Manager:

To upgrade the restored database to the current Argos version, run SetupLauncher.exe from the Argos7Installers folder on the new server. Follow the prompts to upgrade the database to match the other components on the server:

 

 

Phase 4 - Redirect other servers and workstations to use the Argos Communication Service on the new server

Workstations that connected to the Communication Service on Server A will need to be redirected to Server B. We recommend redeploying the client using whichever tool was initially used to deploy the client, such as SMS, Active Directory Group Policy, Sepialine Deployment Center, etc.

If you have additional servers with Argos 7 components (Communication service, Print Tracking, etc), the simplest method for pointing these at the new server is to modify the database configuration settings. This method can be used on workstations to redirect the Desktop Client, if desired.

  1. On the server, browse to C:\Program Files (x86)\Sepialine\Argos7 and open ArgosDatabase.config using Notepad
                                                                                                                           
  2. Search the file text for Data Source and update the value with the new database server and instance names
                                                                                                                           
  3. Go to Start > Run, type Services.msc and click OK to bring up the Windows Services window
                                                                                                                                                 
  4. Right-click on each Argos service and choose Restart

At this point, all Argos components should be pointing to the new server. Send test prints from all print servers and verify that users continue to receive the Argos Desktop Billing Client when printing, and new print jobs appear in the Manager on the new server.

 

Phase 5 - Retire old Argos Integration Services

The final step in the migration is to make sure that the task executor from Server A is retired. Task executors (AKA integration services) handle tasks like device-based tracking and project imports, so it's very important these tasks are mapped to an active server. 
  1. Open Argos Manager on the new server, select View > Settings                                                                                                                                                                                          
  2. On the Task Executors tab, highlight the old server and click Retire... 
  3. If any Integration tasks (project import, user import, HP Designjet integration, etc) are still using the old integration server, you will be prompted to reassign them to the new server. Select the new Integration server from the drop down list and click OK.
     

 

A Task Executor cannot be removed until it has been inactive for 15 minutes.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.