781-728-9777 tony@365ActTips.com

Question:  How do I move my Act! database from one machine or directory to another?

Answer:

Important Note for remote database synchronization users: If you are using remote synchronization and are moving a main (publisher) database or a remote database, do not use the method in this article to move these databases, as synchronization will not work after moving the databases. To move publisher and remote databases while retaining synchronization, refer to the following knowledgebase article:

How to move a main (publisher) and/or remote database to a different computer while retaining remote database synchronization
Answer ID 19817

Note: The steps in this article are applicable for all versions of Act! from 2005 and later, however in Act! versions 2013 and later there is also a database move feature which can be utilized. For more information, refer to the following knowledgebase article:

How to use the Move Database feature in Act! versions 2013 and later
Answer ID 30304

Backing up the database
The recommended method for moving an Act! database is to make a backup, then restore the backup using the Restore as option. For information on creating a database backup, refer to the “Creating a backup” section of the following knowledgebase article:

How to back up and restore an Act! database
Answer ID 19211

Restoring the backup to a new location

Moving the database to a different folder on the same computer:
Because the Act! database files are connected to the Microsoft SQL Server, no two databases on one machine can have the same name. You must either rename the database during the Restore as process, or if you wish to keep the same database name delete the database from its original location. For instructions on using the Restore as option, refer to the “Restore as” section of the following article:

How to back up and restore an Act! database
Answer ID 19211

If you want to keep the same database name, but do not wish to delete the original files, you can use an alternative method for moving your database. Refer to the following knowledgebase article:

How to copy or move an Act! database without doing a backup and restore
Answer ID 23392

For instructions on deleting a database, refer to the following knowledgebase article:

How to delete an Act! database
Answer ID 14139

Moving the database to a new computer

  1. Copy the file to an external storage device, then take the external storage device to the new computer and copy the files to a local drive on the new computer
  2. Restore the database using the Restore as option. For more information, refer to the “Restore as” option in the following knowledgebase article:How to back up and restore an Act! database
    Answer ID 19211

Note: If you are moving the database to a new location, and you use Internet mail, you must also move your e-mail files. For instructions on moving your email files, refer to the following knowledgebase article:

How to back up and restore your Act! E-mail database
Answer ID 19212

After moving the database

If you had any settings previously configured which required the database location in their settings, such as a database share, Microsoft Outlook Integration, Outlook synchronization, or Google Integration, those settings will need to be reconfigured with the database in its new location. For more information, refer to any of the articles which may apply to you below:

How to Share an Act! Database over a Network
Answer ID 13878

How to configure Microsoft Outlook as your e-mail client in Act! versions 2011 and higher
Answer ID 26832

How to set preferences for Act! and Microsoft Outlook Synchronization in Act! versions v17 and later
Answer ID 38155

How to set preferences for Act! and Microsoft Outlook Synchronization in Act! versions 2011 through v16
Answer ID 27076

How to set preferences for Google and Gmail Integration in Act!
Answer ID 27988

WARNING! This KB article (including any software and related documentation) is provided “AS IS.” Swiftpage disclaims all express or implied warranties of any kind with respect to the article, including but not limited to, any implied warranties of merchantability or fitness for a particular purpose.