MUST Products are Helping Businesses Around the World Translate Access Databases to SQL Server, .Net, Azure and Sharepoint

Our tools are the best value for money upsizing products with the highest translation rate available on the market:

• Powerful self-contained Access Application has no impact to working environments, perfect for working with clients and commissioning on-site.


• Designed by developers, for developers. This tool informs the user of all relevant changes that need to be made to ensure migration is successful.


• Use MUST to easily propose upsizing to prospective clients by quickly running their existing application through the tool.


• MUST automatically translates queries. No other migration product offers this capability; our conversion rate has proved up to 94.6%.


• 30-day money-back guarantee on all MUST product purchases.

MUST Unique Features

• Maps Multiple-Databases Applications
• Maps Multivalue Data and Attachment Data
• Identifies and Corrects Design Problems
• Supports Repeated Migrations for Commissioning Systems
• Simplifies Systems using Schemas
• Generates SQL Scripts
• Automatically Add Auditing Track Fields
• Option to Create Full Database Auditing
• Supports On-Going Development
• Supports SQL Server 2000 - 2012/Express
• Standards for Naming Constraints
• Optimises Your Database Indexing
• Generates Trigger Code
• Reverse Engineers SQL Server to Access
• Converts Replicated Databases
• Identifies Impact of Field Changes

MUST+SQL Additional Features

• Translates SQL
• Maps VBA Functions
• Maps Query Hierarchies
• ADP Conversion
• Maps Existing SQL Server Databases

MUST+WEB Additional Features

• Supports Visual Basic and C#
• Supports LINQ
• Supports Entity Data Model
• Supports SQL Data Sources
• Supports Ajax
• Supports CSS Strategy

---

Upsizing and SQL Translation

• Relationships which will not upsize, ..cycles and multiple cascade paths..
• Understanding problems when converting time data to SQL Server
• Multi-part foreign keys, subtle differences between Access and SQL Server
• Building applications with schemas and database roles
• Resolving issues when upsizing one-one relationships
• Using new SQL Server 2008 Data Types
• Upsizing and SQL Server Collation Codes
• ODBC Drivers and OLEDB Providers for connections from Access to SQL Server
• Access application changes after upsizing to SQL Server: Part I code changes
• Access application changes after upsizing to SQL Server: Part II design changes
• Linked tables and triggers which insert data into other tables
• Choosing between System and File DSN’s
• Relinking tables and views between Access and SQL Server
• Generating default values for fields in a form
• SQL Express backup & maintenance
• Handling tables and views of temporary data
• SQL Azure and Microsoft Access
• Translating SQL data between Microsoft® Access™ and SQL Server - Parts I and II (Visual Systems Journal)
• Solving complex query calculations using nested queries
• Using a UNION in nested queries with SUM calculations
• Converting queries to views, general points to consider
• Converting queries to views, handling IIF using CASE and COALESCE statements
• Converting SQL which refers to screen controls using a parameter table
• Converting Access Append Queries and IDENTITY_INSERT Problems
• Boolean Default Values, when linking Access to SQL Server
• Triggers and Denormalized Tables of Data
• Access and SQL Server Views with Boolean Values; when is True -1 or 1
• View updateability affects with multiple base tables
• View updateability and Timestamp columns
• Getting started with SQL Server Security
• Searching and Displaying Data using a single Bound/Unbound Form
• Packing up Text Fields using a Common Table Expression
• Upsizing Tables with Data Corruption and reserved error -7776
• SQL Server Database Auditing
• Using UNPIVOT to normalize mapped data sets in SQL Server
• Searching and Displaying Data with multiple subforms, Bound/Unbound Form

.net Conversion

• Getting started with the Entity Data Model
• Working with foreign keys in tables and views in the Entity Data Model
• Getting started with LINQ
• Choosing a SQLDataSource, LINQDataSource or EntityDataSource
• Formatting date and currency data in ASP.net
• .net data challenges, drop-down lists and SET NULL on relationships
• .net data challenges, data binding
• Enabling Ajax in WebForms
• CSS Design Strategy
• Altering a webform layout with absolute control positioning in VWD 2008
• Integrating ASP.NET security with SQL Server security using LINQ

VBA to .NET Code Conversion

• Converting Access VBA to VB.NET – Global Variables
• Converting Access VBA to VB.NET – General Principles

.NET to SQLAzure/SQLServer Security

• Integrating SQL Server Authentication in .NET Web Forms
• Passing SQL Server Authentication to SQL Azure Reporting Services

Access General

• Highlight Current Record in an Access Continuous Form
• Query By Form & Query By Where
• Recordsets & QueryDefs
• Creating Tables using DDL, DAO and ADOX
• Domain Functions
• Access Database Security
• Maintaining Access Databases - Compact, Repair & Decompile
• Sandbox Mode In Access 2003
• Query Statistics & Analysis Of Performance - Comments On Access & SQL Server
• Documenting Access Databases

Multi-Tenanted Design

• Multi-tenant Database Design
• Referential Integrity, Multi-Tenanted Solutions, Access and SQL Server

Top of Page