Tuesday, April 26, 2011

Understanding Local Copy Options

In several of the Maintenance screens there are "Create Local Copy" button which have led to some confusion among users. The purpose of these button is take maintenance data stored in remote SQL databases and create a local copy on your PC or server. Then when ZonePro later needs access to that data, it will pull it from the local copy rather than make a SQL call across the internet. It's just another way of reducing remote SQL calls and thereby speeding up your system. The problem is that you should only create a local copy if you are completely done editing the relevant Maintenance database. Once the local database is created, changes made in the Maintenance screen will update the SQL database but not the local copy; and since it is the local database that is being pulled by the application screens, etc., it looks like the changes did not take at all. To help alleviate this confusion I have added a new wrinkle to these buttons. Now when you go into a Maintenance screen, if a local copy of the database exists the "Create Local Copy" button will instead read "Delete Local Copy." Deleting the local copy reverts the button back to "Create Local Copy." If you need to edit a Maintenance database you should always be sure to delete the local copy first if one exists. You can always create a new local copy when you finish. Deleting the local copy is always safe because the real copy is the SQL one that is stored remotely. New updates are available for download that implement this change.

No comments:

Post a Comment