Executing Archive Projects

After you have completed the creation of your target tables and the configuration of the form mappings in your project you can then execute the project to migrate data to SQL Server.

Select Project->Execute Open Project from the menu then select the execution options required.

You can schedule the archive project to run immediately, at a predefined date/time or on a regular periodic basis using the scheduling options:

For more information on scheduling executions, see this article.

By default, records created in SQL Server are identified using the SysID field.  If the archive project is run more than once and a record is found with the same SysID on the same table then it will be updated.

Note that projects can also be run from the command line (Windows Only) allowing you to create a batch script to execute several projects one after the other and to create a windows task to schedule running of this script. More information about command line execition can be found here.