Transferring Your Database To A New Server v1.0 - SWG-Source/swg-main GitHub Wiki

The Oracle database within your VM contains your characters, objects, player cities and progression as well as anything that you have persisted to your game server. The goal here is to copy all of that to a new server.

In order to do this you will need to be able to have both of your servers running at the same time. That does not mean having the SWG game server in each VM running, just booting each to the desktop will be fine.

Depending on the server versions you are using you may or may not have the Oracle SQL Developer application installed within those VMs. Here is a basic overview of what you will need: 1 - VM containing the database that you want to copy 2 - VM containing the database that you intend to replace 3 - A machine (virtual or a host PC) from which to use Oracle SQL Developer to perform the database transfer

This guide will assume that you are going to have Oracle SQL Developer installed on the Windows host PC. You can get the software from here: https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

The actual transfer will be done by having that host PC access both databases and then copy one over to the other. When you have SQL Developer installed, the next thing you need is a connection to each of your VMs. For this guide we will be using v1.2.1 as the source and v2.0 as the destination. The password for each connection is swg as usual. Replace the IP addresses you see in each screenshot with the IP used by each of your VMs.

v1.2.1:

v2.0:

Once you have that done you will see a list that is something like this:

Now we need to initiate the database copy process:

Use the settings shown in this series of screenshots and make sure, twice, that you have the correct VM specified for the source database and the destination database or else you will overwrite everything if you make a mistake.

Click Finish to begin the copying process. You will then see a dialog box like this in order to follow the progress:

If you run into this error message just click YES to continue:

Upon completion you will be shown a summary of the changes made during the copy process:

The next thing you need to do is to correct the entry in the database that holds the IP address for your destination server because you just copied the value from the source server over to replace it.

Double-click on the IP address field, replace the value there with the correct one and then click the highlighted button to save your changes to the database.

You should then see something like this:

Now you need to boot up your destination server and ensure that everything you expected to see there is actually present.