How do I change or move an existing installation?

Version: AbleCommerce Gold

Last Update: 06/06/16

This document is intended for a person who is familiar with SQL database restoration and has access to the server to install AbleCommerce software for the purpose of moving or copying an existing installation.  We also have an advanced version of this document:  How do I Copy or Move an existing installation for Advanced Users which is a quicker way to accomplish the same steps but a little more risky with regards to issues that could go wrong.

Multi-Step Upgrades:  These instructions can also be used to upgrade from an earlier version or AbleCommerce Gold to the latest version available.

 

 

How do I copy or move an existing installation?

The goal of this document is to show you how to copy or move an existing Ablecommerce installation to a different location.  You should review the entire document before attempting to complete this process. If you are moving the installation to a new server, you should make sure that the version of AbleCommerce you are moving continues to meet the system requirements.

 

Definitions

ORIGINAL - refers to the original, or existing installation of AbleCommerce.  This could be a development or production website.

TARGET - refers to the proposed, or new installation of AbleCommerce.  This could also be a development or production website.

 

Prerequisites

  1. Before beginning, identify the exact AbleCommerce version you are running for the ORIGINAL installation.  You can find this information by going to Help > About from the Merchant Administration menu.

  2. Next, identify the database you are using for the ORIGINAL installation.  You can find this information by going to Configure > Security > Database from the Merchant Administration menu.  The information will be within the Current Connection String. (e.g. Data Source -.\SQLExpress)

  3. Find your original license key by logging into your account.  If the development domain or IP is changing, you will need to request a new key.

  4. Backup your encryption key This is a special key file that is used to encrypt sensitive information in the database.  Go to Configure > Security > Encryption Key for more information.  You will need the backup file to restore the key.

  5. Disable SSL if the site you are moving/copying the installation to does not have an SSL certificate installed and operational.

 

Install the TARGET version of AbleCommerce

In this step, you are going to install a second copy of AbleCommerce.  

  • If you are moving or copying the same installation, then find your original software download, or the same version that you are running for the ORIGINAL installation.

  • If you are going to upgrade, then download a full build of the latest version by logging into your account and visiting the Downloads page.

  1. Make sure the TARGET server is running with the minimum system requirements.

  2. Complete a new installation of AbleCommerce by following the Installation Guide.

    • The new blank database used for install will be over-written when you restore your original database.

    • Make sure you install with the correct license key. See License Keys for more information.

  3. Confirm that the TARGET installation is working before you continue.

 

Move Files from the ORIGINAL to TARGET installation

This step assumes you have the ability to copy files from one server to another using FTP or a network.  

  1. Before beginning, make sure that you do NOT overwrite the following files during the transfer:

    • ..\web.config

    • ..\app_data\commercebuilder.lic

    • ..\app_data\database.config

    • ..\app_data\encryption.config

    • ..\app_data\ablecommerce.config

    • ..\app_data\AbleCommerce.mdf (optional, see next section on moving a database)

    • ..\app_data\AbleCommerce_log.ldf (optional, see next section on moving a database)

  2. Copy all of the AbleCommerce files from the ORIGINAL installation to the TARGET installation, except the files noted in Step 1 above.

    Note:  Folders that would typically be customized are shown below, however, it is easiest to copy all files to make sure everything is moved over.  

    • ..\layouts\*.*

    • ..\app_themes\ {your theme} \*.*

    • ..\assets\productimages\*.*

    • ..\conlib\*.*

  3. Confirm that the TARGET installation is still working before you continue.
     

Move the Database from the ORIGINAL to TARGET installation

This step is optional.  

If you want to start with a new database, there is nothing more you need to do.  If you want to move your database, then complete the steps below according to the type of database you are using.

IMPORTANT:  Before making a copy of the original database, make sure to disable the SSL setting within AbleCommerce if the TARGET website does not have an SSL certificate installed and working.

To manually disable SSL, open database and find the StoreSettings table.  Then find the SSLEnabled column and change the value from True to False.

FOR SQL EXPRESS

There are no special steps involved.  You can simply copy the ORIGINAL database over the TARGET database.

  1. Copy FROM:

    •  ..\app_data\AbleCommerce.mdf

    • ..\app_data\AbleCommerce_log.ldf

  1. Copy TO the same location on the TARGET server, overwriting the existing database files.

FOR MSSQL Database

  1. On the TARGET server, create a NEW database container

  2. Restore a backup of the database you wish to move.

  3. Make sure the restored user permissions are added back in, or that you have a new user with full rights to the database.

    - If the database will be moved to a different server, then you can use the same database name but you will need to create the SQL user and password and associate it to the database.

    - If the database will reside on the same server, then you will need to rename the database. (eg. STORE_DEV).  It will not be necessary to re-create the SQL user and password.

  4. If you do not understand how to restore an SQL database, then contact your database administrator for help.

  5. Login to your TARGET installation of AbleCommerce.

  6. Go to the Configure > Security > Database page.  If you cannot access this page, then check your User to make sure you are a member of the "Super User" group.

  7. From the Database Connection String page, you can view your current connection string.  

  8. Now, carefully change the new connection string, making sure to use the new database name and user name (if different).

  9. Check the box stating you understand that providing an incorrect connection string can disable your installation of AbleCommerce.

  10. The box to Encrypt the connection string in the database.config file should already be checked, leave as-is.

  11. Click the CHANGE button.  Confirm the installation is working and that you can view your data from the ORIGINAL database.

  12. If you have improperly entered the database connection string, the installation will break.  Continue to the next section for instructions on fixing this issue.

 

Additional Changes after Moving

There are a few additional steps to perform and some locations within the software that you may need to change to ensure that any path or domain changes won't impact features.

XML Sitemap -

From the Configure > SEO > XML Sitemap page, modify the path for XML Data Path to point to the new location.

Encryption Key -

Restore the encryption key from your backup.

Re-crypt your Database Connection -

From the Configure > Security > Database page, select the option to Encrypt the connection string in the database.config file.

Store Domain

From the Configure > Security > System Settings page, change the Store URL if needed.

 

Manually Changing the Database Connection String

The database connection string is encrypted in the file ..\App_Data\database.config

Here is how to modify the database.config file so you can enter your new database information.

  1. Make a backup copy of ~\App_Data\database.config

  2. Take a copy of the following code:

<connectionStrings>
<add name="AbleCommerce" connectionString="Server=yourserver;Database=yourDB;Uid=youruser;Pwd=yourPW;"  providerName="System.Data.SqlClient" />
</connectionStrings>

  1. Paste it into your database.config file.

  2. Modify the connection string to have the correct new server, database name, username, and password information.
    (remove any unneeded breaks)

  3. Save the updated database.config file.

  4. Login to your AbleCommerce installation to confirm it is working properly.  If not, re-check your database settings and make any changes.

  5. Go to the Configure > Security > Database page and check the box to Encrypt the connection string in the database.config file.

  6. Check the box stating you understand that providing an incorrect connection string can disable your installation of AbleCommerce.

  7. Click the CHANGE button.  This will re-encrypt the database connection string for added security.

 
 

Tricks for a Seamless Transition

An AbleCommerce license key responds to the domain it was initially created with.  When you enter a new license key into a working AbleCommerce installation, the URL will automatically redirect to the domain the key is associated to.  If you are trying to change a development installation into a production installation, this could cause some issues if you are trying to access a domain name that is using a different address.  

Here is a suggestion that will allow you to test and work with a domain before the DNS is changed and propagated.

  1. Find a file called "hosts" located in C:\WINDOWS\system32\drivers\etc

This file contains the mappings of IP addresses to host names. Each entry should be kept on an individual line. The IP address should be placed in the first column followed by the corresponding host name. The IP address and the host name should be separated by at least one space.  Make a backup of this file before modifying.

  1. Add an entry like this:

    200.100.50.25 www.myablestore.com

  2. This will map the new IP to the domain.  Save the file when finished.

  3. Next, you will need to flush your DNS by closing down any browser running on the server.

  4. Open a command prompt and type IPCONFIG /FlushDNS

You can make this change on the new server and from your local computer.  This will allow you to test the AbleCommerce installation before making the final change to your DNS.  

 

 

Copyright © 1994 - 2016 AbleCommerce.com, All rights Reserved | Privacy Policy

A division of Able Solutions Corporation - Vancouver, WA - United States 98687 Phone. 1-800-292-7192