Database Migration Tool - Use and Best Practices

The Database Migration tool is used to migrate Printers, Users, Client Custom Fields and Jobs from a Print Audit 6 database to a User Management database.  

We highly recommend engaging our Professional Services team when moving from Print Audit 6 to User Management but if you elect to do it yourself, then the best practices included in this article will help minimize any errors that may occur in the Database migration:

  1. Make sure the Print Audit 6 server backend is upgraded to at least 6.14.  Don't try to migrate from an older version of PA 6.
  2. On the UM server, shutdown IIS to block any other connections to the UM database.  Don't try the migration when UM making live connections to the database.  
  3. Keep the number of jobs being migrated to a minimum.  The more jobs you try to migrate, the greater the chance that a job in PA 6 is going to cause the migration to fail.  “No jobs” is best.
  4. If dealing with a large customer database with a lot of job data, try a month's worth of job data as a test first.  Expand the jobs window only if the test works.

If you looking to use the Database Migration tool:

  1. Login to the User Management server.  Locate the UM Release and Task Services in Windows Services.  Stop both services before starting the migration.  
  2. Launch the Database Migration Tool under User Management on the server UM has been installed on:
  3. Select type of Print Audit 6 database - Access or SQL server.  (The database type can be determined in the Print Audit 6 Administrator by going to Tools --> Set Database).  Click Next.
    DBType.jpg 29.81 KB
  4. Access - you'll need the location of the pa6db.mdb file.  Browse to the location, select the file and click Next.
    AccessDBMove.jpg 36.19 KB
  5. SQL Server - you'll need the Server/Instance, user and password used for the PA 6 database.  Click Next.
    SQLMove.jpg 50.07 KB
  6. You'll need to put in the Server/Instance and Database name, login and password of the User Management.
    ummoveto.jpg 65.64 KB
  7. 5. Once authenticated to the UM database, choose whether to migrate all jobs, no jobs or jobs after a certain date.  In addition to jobs, the Database Migration Tool will migrate Client Custom Fields, Printers and Users.
         
    selectjobs.jpg 51.57 KB
  8. If the database migration is successful, restart IIS (if it was stopped) and the User Management services (Release and Task). 


How did we do with this article?