Migrating projects in shared mode

  

Petra Workgroup uses a different database requiring older Petra project database tables to be upgraded or “migrated” using the Project Migration tool.  This tool can remotely migrate projects on any server connected to the network but for best performance should be run  on the computer where ElevateDB Server is installed.

Things to know before migrating

  • The migration process only applies to a projects database tables and does not affect external files, such as overlays and grids.
  • Projects only need to be migrated once
  • Migration cannot be undone
  • Migration does not erase any data from the original v3 project
  • The Migration Tool looks in the Petra v4 installations Parms directory for projects by default
  • Available projects are listed by name, project path, INI path, shared status, and status

Starting the migration tool

You can launch the Project Migration Tool from:

  • Petra: Project > Open > Project > Launch DB Migrator
  • Main module: Project > Launch DB Migrator
  • Windows Start button, IHS > Petra > Project Migration Tool
  • :\Database Server path\ ElevateDB Migrator folder\ElevDB Migrator.EXE

Click to enlarge image

Server Address

This option sets the IP address or hostname of the database server.  To migrate projects on a local machine, set this field to localhost or 127.0.0.1.

Server Port

This option sets the port of the database server.  To migrate projects on a local machine, set the port to 12010.

EDB Login

This option sets the username.

Password

This option sets the password.  The username and password will need the appropriate permission.  Brand new DB servers will only have a single administrator user at first.  EDBLogin: Administrator; Password: EDBDefault

Auto-Drop Existing DBs

This option automatically replaces projects with the same name already on the Database Server.

For Invalid Project Names

This option determines how the Migration Tool handles projects with names that start with a number or exceed the 40 character limit.

  • The Skip Migration option completely skips the migration.  
  • The Prompt user for new name requests a new name for the project.  
  • The Automatically truncate and/or prefix name with:both truncates characters beyond the 40 character limit and/or adds a prefix for project names that start with a number.