HeroEngine DB Migration Tool

Jump to: navigation, search


He server.png Documentation on this page is intended for customers of HeroEngine managing their own server(s).

The HeroEngine DB Migration Tool is used for migrating database schemas between different versions of HeroEngine.


CautionSign.gif Use with caution, as selecting the incorrect version to upgrade your world database tables beyond the desired version will cause many problems. Back up your database before beginning.


Oracle 10g Release 2 ODAC
	Download the File
 		ODAC1020221.exe 206 MB (216,841,603 bytes)
 	 	Installation Instructions
 	 	Important: If you are installing ODAC on Windows Vista or Windows Server 2008, consult the installation instructions for installation steps on these operating systems.
Download Includes

 		Oracle Data Provider for .NET 1.x
 		Oracle Data Provider for .NET 2.0
 		Oracle Database Extensions for .NET 1.x -- for upgrade only
 		Oracle Database Extensions for .NET 2.0 -- for upgrade only
 		Oracle Provider for OLE DB
 		Oracle Objects for OLE
 		Oracle Services for Microsoft Transaction Server


The DB Migration Tool can be used only by licensees with full or source code licenses. The tool is available from the HeroEngine Downloads page, or can be built from source. The version of the tool available for download contains all valid releases.


To build from source, access the product in the Perforce Depot, currently found at //depot/HeroEngineDBMigration/RELEASE/... .

The DB Migration Tool is built using Visual Studio 2013 (as of January 2014), opening up the RELEASE/<<Version>>/Migrate/Migrate.sln solution file. Set the run directory to be the solution directory in the Migrate project settings.

There is a "Migrate.ini" file located in the RELEASE directory which contains the "he_admin_password" and "servers" lines. Customize those for the licensee installation.


DMS system.png

Once opened, it can be seen that there are two tabs in the DMS Tool: "Databases" and "Files".

On the "Databases" tab, the available databases will be listed.

Adding databases

To add new databases, the Migrate.ini file must be modified directly, to add the desired databases on the "servers" line, each separated by a space.

Example ini file:

he_admin_password = *****
editor = notepad.exe
scriptPath = Scripts
servers = hjoracle opal bart evaldb evaldb2 onyx 

Upgrading a database

From the "Databases" tab:

Clicking on the Upgrade button accomplishes the upgrade of the specified schema, after which the release number in the "Schemas" list will switch to green, to indicate that it is up-to-date.

Files tab


(please expand)
Personal tools