As an alternative to directly upsizing your application to an available SQL Server, MUST can generate SQL Server Script files using the “Pack & Go” menus.

Three script files are generated Pre-Migration to create your SQL Server Tables, Schemas and Synonyms, Data-Migration to pull the data into SQL Server, and Post-Migration to create Indexing, Relationships and Triggers.

This approach allows you to create a set of files which together with your Access databases can then be taken to a remote server (which does not need Microsoft Office to be available), or give to others to run and generate your system.

Pack & Go is ideal for use by dba’s allowing them to review code before it is executed on a target server. It also gives you complete control over the upsizing process, allowing you to directly edit the script files before a system is upsized.

Pre-Migration Example

Show below is a short example of the output generated for this step.

Click here to view the entire script file.

Data-Migration Example (Not available in SQL Server 2000)

Show below is a short example of the output generated for this step.

Click here to view the entire script file.

Unfortunately this feature is not available in SQL Server 2000 as the data transfer mechanism has a number of technical difficulties which means that it wil not work in all circumstances.

Post-Migration Example

Show below is a short example of the output generated for this step.

Click here to view the entire script file.