A single product purchase supports all versions of Access and SQL Server as shown below
What our customers say about MUST
This clearly represents a superb return on investment
"We have successfully upsized 5 large and complex MS Access databases to SQL using
MUST. It had paid for itself in, the time it saved us, on completion of the second database.
This clearly represents a superb return on investment"
Mervyn Porter, codepagesystems.com
The querydef conversion rate I achieved was well over 90%.
“MUST is developed by an accomplished upsizing practitioner ; it is much more than a manufacturer’s ‘tick the box’ tool.
Numerous features are available to fix the underlying issues that cause upsizing errors. Even troublesome unique indexes
with multiple nulls are seamlessly converted to triggers. Every row in the database is accounted for.
Changes, fixes, errors and much, much more are logged, pinpointing any residual issue.
The querydef conversion rate I achieved was well over 90%. There is a solution for embedded form references and a
test harness for checking the upsized results. Queries that don’t upsize because, say, they reference linked spreadsheets
are clearly identified. Optionally, SQL scripts are generated making the process reproducible.
Ideal for our phased deployment of read only users first, with a daily overnight data refresh from Access to SQL Server
during the transition.
Gillian Mackenzie, Database Administrator, BizzEnergy Limited”
A great time-saver
I work for East Berkshire College, developing in-house applications. I struggled for some time trying to link an Access front-end to SQL Server - my applications always seemed to be too complex for the Microsoft upgrade tool.
MUST has made upgrade so much easier, I can understand it and customize the procedure as I wish.
It's a great time-saver too, and the company is so approachable and supportive.Great value for money!
Steve Pitt, East Berkshire College
MUST ticks all of the boxes for excellence!
My business is designing and building databases to meet specific client requirements and
I have found MUST an invaluable tool for migrating Access data to SQL Server.
Of the host of features available the few that I use regularly and that have given me enormous benefit are:
- The ability to split the data migration into several steps each of which can be managed individually
- The identification of all problems within the Access data enabling these to be fixed before proceeding further
- The scripting of the Access tables so that the performance advantage of SQL Server can be fully utilised (and to provide templates that assist my development of additional data facilities)
The whole package is then topped up with a support service that responds both rapidly and friendly to offer guidance on all individual migration needs.
MUST ticks all of the boxes for excellence!
Frank Douglass, Director, Delian Systems Ltd
10 Ways To Improve Your Productivity When Upsizing Access Databases To SQL Server
- Improve managment of your applications by partitioning a large Access database into manegable chunks using schemas.
- Bring together several Access databases into a single unified SQL Server database.
- Generate readable script files for better control and more flexible development.
- No need to install special software, supports all Access versions from 2000 to 2007.
- Get a smooth repeatable transition for swapping over live systems.
- Automatically optimise your database performance as part of the migration.
- Identify and fix problems in your Access data and database design.
- Supports SQL Server 2000, 2005 and SQL Express.
- Choose to add auditing features to your application.
- Automatic translation of SQL to Views and Stored Procedures.
Migration For .NET Developers
For .NET developers with a need to Migrate MS Access databases to a SQL server
platform. The product offers a simple to use interface which is designed to both
enable you to obtain a quick upsize, and then delve behind the screens for
better control of the process. MUST has been used to migrate multiple Access
databases with average database sizes over 700 MBytes. Professional features
include a change log to record all changes made to the application and an error
log for resolving upsizing issues.
The new MUST+SQL Translation features will allow you to uplift
existing Access queries into Views and Stored Procedures. Existing form and query parameters
and identified and automatically converted to minimise your workload.
MUST+Web will translate Access forms into .net web forms.
Top of Page
Upsizing For Access Developers
For Access developers, MUST will let you lift multiple back-ends into a single
SQL Server database. MUST assist in automatically correcting your existing
applications, adding primary keys to tables, correcting illegal dates and has many
other auto-correcting features. With MUST+SQL developers can pick troublesome sets of queries
and have these automatically translated to run on SQL Server for improved performance.
Supporting SQL Server 2000, 2005 and SQL Express
MUST and MUST+SQL supports SQL Server 2000, SQL Server 2005 and SQL Express. MUST+Web supports
SQL Server 2005 and SQL Express. The products also
supports the very latest ideas in using schemas to implement partitioning of upsized
Access applications.
User Interface, example ribbon menus
Data and Structure Migration : The menu ribbons in MUST guide users through a simple sequence
of operations reading from left to right making the software very easy to use,
the example below shows the ribbon for migrating structure and data.
Query Translation and Migration : offers a simple series of automated steps to
migrate your SQL, features include a VBA support library, automatic VBA function hunting to create SQL Server
function templates to support existing VBA code, automatic SQL nesting for complex calculations and
automatic identification of all references to screen controls and query parameters and modification of SQL
to use a new substitute parameter table in your queries. Other features include detailed query dependency analysis
and automatic SQL Testing to isolate type conversion issues.
Top of Page