Back

Moving SmartConnect 21 to a new server

Published: Sep 08, 2023
Post Author Written by Maksudul Haq

There are two methods available when moving the SmartConnect to a new server. The best option is to export all your maps, objects, and variables through the SmartConnect user interface and import them into a brand new SmartConnect install on the new server. The other option, is to back up your current SmartConnect database and restore it on the new server.

If you are moving a SmartConnect 2018 database, please follow this article instead.

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.
 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.

Even if you have imported your maps, the Connections may need to be updated to point to new servers.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.