Update Status Page

The Update Status page is after initiating a conversion process. It charts the conversion process and provides SQL Server version information.

 

 

Table/Query: The table or query currently being analyzed or deployed.

 

Phase: There are two phases to update process, Analysis and Deployment. Scriptoria first compares the Access and SQL Server data models to determine the changes that need to be made to synchronize the databases.

 

Operation: A description of the operation being performed by Scriptoria.

 

SQL: During deployment phase, this field shows the SQL Server SQL being executed.

 

 

Press the STOP button to abort processing. Note that with some operations, like IMPORT or LOAD, processing may take some time before halting. Scriptoria has no control over the behavior of other programs or API's.

 

Press the SQL button to view the DDL and/or DML generated for the current SQL Server update operation. This button is enabled after the Analysis Phase is completed.

 

Press this button to display the operation status of each SQL Server statement after deploying the generated DDL and/or DML. This button is only enabled after completion of the Deployment Phase of the operation.