HeroEngine DB Migration Tool

From HEWIKI
(Difference between revisions)
Jump to: navigation, search
Line 2: Line 2:
 
{{Unmanaged}}
 
{{Unmanaged}}
  
The '''HeroEngine DB Migration Tool''' is used for migrating [[database schemas]] between different [[versions]] of HeroEngine.
+
The '''HeroEngine DB Migration Tool''' is used for migrating [[database schemas]] between different versions of HeroEngine.
  
 
{{-}}
 
{{-}}

Revision as of 20:46, 8 November 2012

Contents

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.


Installation

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.


Preconditions

Oracle 10g Release 2 ODAC
	Download the File
 		ODAC1020221.exe 206 MB (216,841,603 bytes)
 	 	Installation Instructions
 	 	 
 	 	Important: If you are installing ODAC 10.2.0.2.21 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 10.2.0.2.20
 		Oracle Data Provider for .NET 2.0 10.2.0.2.20
 		Oracle Database Extensions for .NET 1.x 10.2.0.2.20 -- for upgrade only
 		Oracle Database Extensions for .NET 2.0 10.2.0.2.20 -- for upgrade only
 		Oracle Provider for OLE DB 10.2.0.2.20
 		Oracle Objects for OLE 10.2.0.2.20
 		Oracle Services for Microsoft Transaction Server 10.2.0.1.0

Download

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.

Source

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 2005 (release 1.23) or Visual Studio 2008 (release 1.24 or higher), 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.

Usage

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

DMS2.png


(please expand)
Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox