<< Click to Display Table of Contents >> Navigation:  General Functions > Performing Local Backup > Considerations

For data stored in Access

The Secure File Transfer (SFT) client reads table structure meta-data from the MIE and uses that data to create your local Access database.  It checks the MIE's meta-data before each transfer, and if the MIE's structure has changed, it will update the structure of your local Access database to match.  Before it updates the structure, it first creates a backup of your existing database.  

Consideration #1 - Data from the MIE can create a very large local Access database.  You must make sure enough disk space exists to accommodate not only the current Access database, but any backups that the SFT client needs to make as well.

Consideration #2 - Since the SFT client will periodically update the structure of the local Access database, it will erase any additional objects you may have added to that database, to include forms, reports, queries, tables, and additional rows of data.  Therefore, do not modify the Access database being managed by the SFT client.  Rather, link to that database and create queries and reports in another application and/or Access database.

 

For data stored in SQL Server

The SFT client uses the same meta-data from the MIE to decide if it needs to create or modify the structure of a table.  However, since it uses SQL server's ALTER TABLE command to make any structure changes, the considerations mentioned above do not apply.  Any other objects you may have added to your SQL Server database will remain unaffected by structure changes made by the SFT client.