MUST  Upsizing to SQL Server Tool Special

Upsize + Improve SQL Server Query Performance - $US 520  $US 450

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 a video of Access queries being upsized to stored procedures or views   (Adobe Flash Player 9)

Compare MUST and MUST+SQL  or find the Full MUST Access Upsizer Product Catalog
 
 


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.


Special Offer on MUST+SQL for MSDN Flash Readers and Access Unlimited Readers

Expires 31/12/08

 
US$450: Purchase using Paypal and you receive a free copy of the Toolbox as  well

 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.

What do you need?

To make this upsizing software work, you will need Access 2000, XP, 2003 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 2000, XP, 2003 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