Introduction

SP Upgrade is able to migrate (convert and transfer) the core data from Joomla! 1.5 (from now on called source) to Joomla! 1.6, 1.7, 2.5 or 3.x (from now on called destination) and above. You install SP Upgrade on the destination site, and you transfer items from the source database.

In no case an item will overwrite an existing item with the same id during transfer if you choose it. There is also a restriction in Joomla! where you cannot have the same alias of an item under the same parent. Taking these facts into consideration there are two important options you have to decide before the transfer.

  1. If there is duplicate id, whether:
    • to transfer the item with new id, (recommended for already existing destination site with extensions, or other data installed)
    • replace existing items (recommended for new empty destination sites)
    • or not transfer at all.
  2. If there is duplicate alias, whether to transfer the item with different alias, or not transfer at all. (recommended to transfer with different alias)

The component keep history of what is already transferred. This is necessary to keep track in case you have a disruption of the process for any reason (timeout, memory, network)

It is strongly recommended to backup your database before proceed with the transfer, just to be on the safe side.

Another very good and more detailed guide you can find here: http://www.ostraining.com/blog/joomla/sp-upgrade/

Installation

he Joomla package (zip file) is installed just like any other standard Joomla component from Extensions Manager in back end. It is installed on the destination site and NOT on the source. See below image:

SP Upgrade installation

Options

To access the options press button 'Options':

SP Upgrade options

Configuration

SP Upgrade configuration

SP Upgrade configuration new ids

Same IDs Handling: Choose how to treat items with ids that already exist in the destination database.

  • Transfer items and save with new IDs, or
  • Do not transfer item, or
  • Replace existing items.

Duplicate Alias?: Choose whether to transfer items with different alias or not, in case an existing item under the same parent has the same alias.

Note: The option fore replace existing items is not valid for users.

Batch: The number of items to transfer in each cycle.

Database

Those are the database credentials of the source database. Those credentials can be found in your source site configuration.php file.

SP Upgrade options database

Host: In case both your databases are on the same host then write localhost. In case of remote transfer here you have to write the remote source host name, or IP. In case you have trouble identify what is this, you should contact your host provider.

Database Name: The source database name.

User Name: The user name of the source database. This is not the Joomla admin user.

Password: Password of the user to the source database.

Database Tables Prefix: The source database tables prefix name. Something like xxxxx_

FTP

Those are the FTP credentials of the source site. They are necessary to enable ability to transfer files, like images, templates and other extensions media files.

SP Transfer FTP configuration

FTP Host: In case both your sites are on the same host then write localhost. In case of remote transfer here you have to write the remote source host name, or IP. In case you have trouble identify what is this, you should contact your host provider.

FTP Port: Usually this is 21. 

FTP User Name: The FTP user name of the source host.

Password: Password of the FTP user to the source site.

FTP Root: That could be / or any other sub-directory that is present on the source site.