SP Transfer is able to transfer various items between two Joomla! databases. You install SP Transfer 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.
From this view you have the ability any notes, and whether everything is transferred successfully.
Files Transfer View
On tab Files Transfer you have the ability to choose any file, or folder to copy to the destination site.
Installing the package is the same as with any other Joomla! component. Go to your site's back-end Extensions, Manage and click on Browse. Locate the ZIP package and click on Upload and Install.
Configuring the component is essential for the success of the transfer process.
Database Transfer View
On tab Database Transfer you have the ability to choose individual records from any table in the source database.
Core Joomla! Data Transfer View
Just choose what you want to transfer and press button transfer.