Home | About | Resources | Contact | Partners

Useful Published Books

Technical Support Library

Upsizing Database Structure & Data (MUST/MUST+SQL/MUST+WEB)

This page contains a summary of key resources that you will find useful in getting started with MUST, MUST+SQL and MUST+WEB. The on-line articles are also available to link directly into the help system.

The page has a flow which takes you through the process of upsizing:

  • Planning Your Upsizing
  • Upsizing Proccess
  • SQL Translation
  • Web Conversion


The following articles should be read in relation to planning to upsize a database, they explain some of the subtle differences between Access and SQL Server, will help you decide on how to use file dsn’s, the best type of drivers to use, and how to plan using schemas and security to achieve a good design.

Creating Auditing Databases and Adding Auditing Fields

MUST has special features to add auditing fields to your tables and to create auditing databases which track row level changes to data, these features need to be considered during the planning phase, as choices must be made before starting a conversion

Upsizing Data and Structure

The video below will take you through the most common sequence of steps required when upsizing a database.

MUST standard edition

The following articles describe how to understand issues that can arise as you are converting the database.

After Upsizing, Application design

The next group of articles will help you to understand how performance is effected by your Access design, and provides additional stock code for re-linking tables and views, and performing maintenance tasks in SQL Express.

Commissioning a System

After you have completed your development work, you will decide to upsize the live system, these resources discuss how to do this.

Converting SQL to Stored Procedures and Views (MUST+SQL and MUST+WEB)

The video below will take you through the most common sequence of steps required when converting your SQL from Access to SQL Server.

MUST+SQL professional edition

These resources are aimed at helping you understand the techniques which MUST uses when translating SQL, a key technology to understand is our unique approach to converting query and screen parameters.

Repeating SQL Translation

MUST enables you to do partial conversions on blocks of queries, these articles in the section illustrate how this can be used.


Converting Access Forms to .Net webForms (MUST+WEB)

The articles below will explain the CSS design strategy that MUST use and its support for Ajax.

MUST supports SQL, LINQ and Entity data sources, these articles will help you decide which technology is best for you.

The articles below contain background information which is useful in understanding our approach topics such as Data Binding and drop-down lists (this is a very important article and MUST has special features for checking data intergrity to highlight possible issues here).

The articles below discuss converting VBA code to VB.NET.

Reverse Engineering

Reverse engineering is a process which allows you to back-convert a set of SQL Server tables and relationships back into Access.

We also have a number of articles on various Access topics from using simple query by form (which is useful to understand if you are not an Access expert, but get landed with an Access database to convert), to the basics of writing recordset and querydef code.



Latest Articles

Multi-tenant Database Design

Top of Page