Skip to content
+1-888-319-3663

HELP ARTICLE

Moving SmartConnect 21 to a new server


There are two methods available when moving SmartConnect 21 to a new server.

Export-Import Method

  1. Start by Exporting maps from the SmartConnect 21 old server.
  2. In the Integrations tab, click Export.
  3. Select the maps and Folder directory and click on the Export


 4. On the New Server, install the same version of SmartConnect 21 as you would on a new install, as outlined in the manual. Here is a link to download older versions of SmartConnect.
 5. Login in SmartConnect and Run System Maintenance.
 6. Create all SmartConnect connectors manually for the new installation.
 7. Go to File > Maintenance > Setup for SmartConnect Temporary File Location for the exported map file import.



 8. Click on the Import Integrations button and data sources.
 9. Follow the Import Wizard and Integration Setup for the New Values to Save and complete importing.

      Database Restore Method

      1. Run this Script to clear the SmartConnect log tables, so you aren’t transferring more than necessary.
      2. Create a backup of the SmartConnect database. Here is a link with steps to create a backup.
      3. On the new server, restore the SmartConnect database. Here is a link with steps to restore a backup.
      4. On the new Server, Install SmartConnect 21 same version and run the SmartConnect Configuration. Create a new instance to set the restored database as an active instance.
      5. Next, we need to remove the old SmartConnect user that owned the database, and create a new one to own the database. The new user can have the same name as the old one. Run the below script to remove the user (assuming the database and user are both named SmartConnect).

        USE [SmartConnect]

        DROP USER [SmartConnect]

        GO 

         6. Create a new user named SmartConnect and assign them db_owner with a default schema of dbo for the SmartConnect database. Here is a link with steps to create a new SQL user.

         7. Install SmartConnect and point it to the existing SmartConnect database.

        Check other Database References

        Even if you have imported your maps, the default connections and tasks can still be pointed to the old server.

        Check the ODBC, OLEDB, and MSSQL data sources for references to the old server.
        SmartConnect >>Maintenance tab

        Check your tasks on maps to make sure there aren’t any SQL Command or Script tasks using the old server.
        SmartConnect Map >> Tasks tab


        RECENT POSTS


        Configuring Salesforce Integration User
        Business Central Extension Publish Error
        Re-registering a Change Data Source in Business Central on SmartConnect.com
        eConnect error 4628 - The Tracking Number (Tracking_Number) is empty
        Troubleshooting Salesforce Realtime Triggers

        POPULAR POSTS


        SSL Security error using OLEDB Connection
        This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
        Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
        The server process could not be started because the configured identity is incorrect.
        Using WINSCP and a task to upload or download files from an SFTP site

        CATEGORIES

        TAGS

        Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release Salesforce Salesforce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

        Integrate & Automate without Any Code.

        SmartList Data has Never Been Faster.

        The Easiest Way to Report on GP Data.