General Functions > Performing Local Backup

The MIE can be configured to manage a backup copy of several of its tables to your local machine or network share. When the MIE is configured to manage a local backup copy, it keeps the copy synchronized with the master data on the MIE. The local copy is stored in either an Access database or a SQL Server database and may be used for additional purposes such as ad-hoc reporting.

To manage local backups, hover over Import/Export on the left menu and choose the Manage Local Backup menu option from the fly-out menu. You must have sufficient MIE privileges to see these menu options.

Note, managing local backups requires that you install the Secure File Transfer client on your local machine. You will see a link to install the Secure File Transfer client at the top of the Manage Local Backup page.

If you choose for your local database to be in Access, the Secure File Transfer client will create and manage the database using the directory and filename you specify in the settings. It will also upgrade the structure of that database from time to time. You do not need to have Access installed on the machine.

If you choose for your local database to be SQL Server, you will need to create a database on that server and assign access to a given account that the SFT client can use. You then define a local SQL Server connection that the SFT client will use to connect to the database. Once the database and access has been granted, the SFT client will take care of creating new tables and updating the structure of tables over time, as well as keeping data synchronized with the MIE.