Part 1. Configure a Local Area Network Server
Follow this guide to configure a SalesPartner server using the open-source SQL server MariaDB relational database system. This is a foundation example for multi-user environments including on-premise, hybrid-cloud, and cloud-only.
Requirements:
On the host PC which is running Windows 64-bit operating system, SalesPartner is installed and updated to version 14. The copy of SalesPartner that is being migrated must be backed up using Offsite Internet Backup.
1. Install MariaDB
The latest production MariaDB 64-bit installer (MSI) can be downloaded from the MariaDB website:
https://downloads.mariadb.org/
Run the installer using the default settings. On the Default instance properties window enter a new root password and tick Enable access from remote machines for 'root' user.
Click Next to install as a service and enable networking. Then click Install.
2. Create a new database
Open HeidiSQL and click New to create a new session named salespartner. Select the Network type = MySQL (TCP/IP) Enter the root password you created previously and click Open.
Right click on your session in the left panel and click Create new > Database.
Name the new database salespartner.
3. New Connection Definition
Open the FDAdministrator application in this location:
C:\spartner\FDAdministrator.exe
- Click New to create a new connection definition and name it MariaDB
- In the Driver ID drop down menu select MySQL.
- Enter the Database name salespartner
- Enter the username and password
- Enter the local host IP address: 127.0.0.1
- Right-click on the new MariaDB definition and click Apply.
To view and check the new connection details open c:\spartner\FDConnectionDefs.ini
4. New Desktop Shortcuts
Create a copy of the existing desktop shortcuts for SalesPartner and SalesPartner Utilities, and rename them:
- SalesPartner MariaDB
- Utilities MariaDB
Open the Properties for each new shortcut and in the Target field enter as shown then Apply:
- C:\spartner\rezy.exe /db=MariaDB
- C:\spartner\rezy.exe /utilities /db=mariadb
5. Restore Data into MariaDB
Important: Open the Utilities MariaDB shortcut and verify the connection info before continuing. In the following step the tables will be purged in order to create the required empty tables for the new database.
Open Advanced, Empty / Reread Data File, Empty All Tables and click Yes to proceed. Click No when you are prompted to leave the system table. ETC = 2 minutes.
Close Utilities MariaDB and open SalesPartner MariaDB. Follow the launch prompts then open the System File and enter the registration for the copy of SalesPartner you intend to restore. Change the System Number, then Close SalesPartner to save changes.
Open Utilities MariaDB (check connection info), OffsiteInternetBackup. Log in and Restore the latest backup. ETC to complete restore 5-25 minutes depending on database file size.
Open SalesPartner MariaDB to confirm that the data has restored into the new environment.
Continued in Part 2: Configure a network client
RSS Feed
