MUST  Upsizing to SQL Server Tool Catalog

Quick and Easy Upsize Software - $US 199

Standard version of MUST

Upsizes Access database tables, indexes, table and field validation rules and relationships to SQL Server.

  • Identifies and corrects problems The system will identify any problems which could prevent your data being upsized, or lead to future design problems due to missing defaults. In addition to identifying problems the system has tools which will automatically fix the problems.
  • Generates SQL scripts Generates scripts to create tables, upload data and create indexes
  • Removes indexes that aren't needed (SQL ignores them anyway)
  • Supports repeated migrations for commissioning Supports multiple loads to make for simple commisioning
  • Supports SQL Server 2000/2005/Express/2008
  • Replaces the Access upsizer without the hassle Easier than Access upsizer if you have a faulty database
    Read the help in more detail

MUST Standard Video Video of a database being converted and queries being upsized to Views etc (11 Minutes Flash High Resoultion) or See a video of a database being converted  (12 Minutes Windows Media)
or View the MUST Access Upsizer Videos page


 Purchase from SWREG  (a Digital River Company)  or PayPal®  or   Download trial version

Upsize + Improve SQL Server Query Performance - $US 299

Convert Access queries to views and parameter queries

Upsizes Access database tables, indexes, table and field validation rules and relationships to SQL Server. Converts queries to views and queries with parameters and functions to stored procedures.

  • Action queries are converted to stored procedures INSERT, UPDATE and DELETE queries are converted to Stored Procedures, which can either be driven using variables (which are inserted in the procedure calls), or by extracting parameters from a parameters table. Other SELECT and CROSSTAB queries are converted to Views.
  • Other SELECT and CROSSTAB queries are converted to Views
  • Identification of Query layering & dependencies
  • Query layers are shown in a treeview See the dependant queries in a tree view
  • Identification of VBA Function calls Where Access functions have direct equivalents in SQL Server, the tool substitutes existing Access functions with new SQL Server function.
  • Schema support Read PDF
  • Works with Access databases that are already linked to SQL Server Works with databases that have been migrated with another upsizer
MUST Standard Video See videos of MUST+SQL in action for things like Access queries being upsized to stored procedures or views   (Adobe Flash Player 9)

Purchase MUST + SQL using SWREG   or  Compare MUST and MUST+SQL  or Upgrade to +SQL 
 


Upsize + Query Performance + Produce Web Forms - $ US 499

Conversion Access objects to .NetUpsizes Access database tables, indexes, table and field validation rules and relationships to SQL Server. Converts queries to views and queries with parameters and functions to stored procedures.

Converts application interface to web based framework. MUST+Web will take your Access application to the next level by translating Access forms into web forms for use with Visual Studio or Visual Web Developer Express and provide the hooks to enable you to launch Reports using Report Server. Doesn't work with SQL Server 2000. 

  • Re-packaging the SQL in forms/reports and controls
  • Converting single forms, continuous forms  Single forms are converted to use the DetailsView control and continuous forms are converted to use the GridView control, in addition for GridView controls an additional DetailsView is constructed to allow inserting data (a feature un-available with the standard control).
  • Subforms are converted Subforms are converted into the appropriate GridView or DetailsView controls and parameters are added to related forms where possible to link the forms together in.
  • Supports Visual Studio 2005 and 2008
  • Read a case study on upgrading


Purchase MUST + WEB from SWREG   or   Read the +WEB FAQ page  or  Upgrade to +WEB

Notes: Web form upsizing does not support SQL Server 2000 and remember that to upsize to Visual Studio, you need to upsize all tables and queries to SQL server.

Download The Trial Database

Before downloading the software, please read the Terms and Conditions

Download  Download the trial version and create registration codes

 
Note: MUST software and logos are the property of ASC and Associates, Access and SQL Server logos are owned by Microsoft.

Hover over The system will identify any problems which could prevent your data being upsized, or lead to future design problems due to missing defaults. In addition to identifying problems the system has tools which will automatically fix the problems. for more information on topic or read the topics in more detail.

Purchase Using PayPal or SWReg

You can purchase the MUST products using either Paypal using the options below or
purchase using SWReg (a Digital River company)

MUST Options (includes free Smart Access Pack (Gold or Silver or Bronze)
Designed for Microsoft Access 2010 and 2007

Read about your Free Smart Access kits here

Gold  Silver  Bronze

 About MUST

The product that we are talking about here is called MUST, an Access tool developed by Andy Couch, a fellow Access MVP.

To use the product you place the MUST  MDE file in the same folder as your Access database(s), open it up, identify your Access database, nominate your SQL Server database and you are away. It is not an add-in so that makes it easier.

Garry Robinson
Office Access MVP from Australia

How does it help you?

Q. When I tried converting a database using the upsizing Wizard it failed to convert all my data, hope can you help with this?

A. MUST automatically validates the date time fields and required fields, listing and correcting bad data, removing any obstacles to converting your data.

Read more Questions and Answers

Best pricing, safe purchase

As the only Authorised reseller for MUST, we will offer you the best prices for the product.

We have been selling our software on the web for 10 years now and we only use the biggest software sales sites for selling because handling credit cards online is not our speciality.

All prices quoted here are single developer licences. See FAQ

What do you need?

To make this upsizing software work, you will need Access 2010 or 2007 and you will need SQL Server 2005 or 2008 or 2000 and you will need  Administrator rights on that server.

For MUST+Web you will need Visual Studio 2005 or 2008

The best way to find out about the software is to view our videos or download and try the trial version.

Licensing.. What do you get

When you purchase the product, you will receive Licensed Access 2010 or 2007 versions of the software that you can use in any of your folders.

A consultant can use the software for all their clients, as long as the clients do not operate or copy or re-distribute the MUST software

A Multi-Developer Single-Site License allows any member of staff within your business to operate the software. However, if your company has multiple physical sites a separate license will be required for each site. See terms and conditions document in downloads