SSW Product
The SSW Upsizing Pro was fantastic! This is the first time I've tried to go from Access to SQL Server 2000 with any type of data and I had one table that kept giving me headaches. I ran the upsizing pro and it reported two fields in the table that had dates prior to 1/1/1753. (I can't believe that SQL server doesn't support dates prior to 1/1/1753!). I fixed the fields and the table uploaded fine. Thanks for a great product. Todd Carlson- Brown-Minneapolis Tank http://www.bmt-tank.com/
 

Awards

Shareware River review
Star Star Star Star

Core Download

SQL Server related productMS ACCESS related productSSW upsizing PRO!

Has your business outgrown your home made Access database? Upsizing is the process of migrating some or all database objects (tables and queries) from a Microsoft Access database (.mdb) to a new or existing Microsoft SQL Server database. If your business is growing and you demand a scalable database solution, upsize from Access Jet to the robust SQL Server environment. SSW Upsizing PRO! is the tool that prepares your Access database so you can convert effortlessly to SQL Server. Upsizing PRO! will prevent known errors, ensuring a smooth migration.

Microsoft Upsizing Wizard upsizes the mdb (if successful) and then creates a report that provides a detailed description of all objects created, and reports any errors encountered during the process.

Microsoft have had their Upsizing Wizard for a many years and while it works fine for some, other developers report to newsgroups that it has a surprising amount of shortcomings. While some of them are bugs, most of the issues are simply because Access and SQL Server have different functionality. We believe the best approach is to fix errors in the mdb first and this is the approach that SSW Upsizing PRO! takes.

Our clients often ask us to upsize their database from Access to SQL Server. With Upsizing PRO, what used to take us hours can now be done at the click of a button.

Works with SQL Server Versions:2000, 2005, 2008

Key Features & Benefits

What about the SQL Server Migration Assistant for Access (SSMA Access)?

SSW Upsizing PRO! is unique in terms of validating data structure and data before and after upsizing. SSMA Access has a good set of rules however there are some issues. See our take on Microsoft SQL Server Migration Assistant Wizard for Access

As an Upsizing Tool, SSW Upsizing PRO! checks your database the way the 'Microsoft Upsizing Wizard' should have done. After you use the generated reports, and made the recommended changes, you can upsize to SQL Server without any worries. Here are some of the useful features of SSW Upsizing PRO!:

  • Wizards guide you through the upgradation.
  • Effective than Microsoft's Upsizing Wizard.
  • Supports upsizing non-unicode datatypes in Access
  • Microsoft Access developers too often use forms and combos bound to large tables or slow queries. Let this wizard analyze your Front-End and tell you what forms are slow and what controls are the culprits in each form.
Main Menu
Figure: SSW Upsizing PRO! prepares your Access database so you can convert effortlessly to SQL Server

More screen shots in the User Guide

Reports

Here are the Before and After Upsizing PRO reports for the Sample Northwind database included with SSW Upsizing PRO! You will need the Microsoft Access Snapshot Viewer to view these links. Download it here You are about to leave the SSW site

System Requirements

PS: It is always recommended you can get all green ticks with SSW Diagnostics - the free utility to check you have all software patches

What does the unregistered version give me?

In respect to the unregistered version we know you want to see it working before you buy it. We aim for that.
Note: we also give free version targeted to the little guys
More details see http://www.ssw.com.au/ssw/KB/KB.aspx?KBID=Q658302

Superior Software provides free phone and email support to answer queries on registered products.

Getting Support

If you need assistance with our software, please check out documentation and our Knowledge Base.

Please send us bug reports and 696e666f72407373772e636f6d2e6175 so that we can evolve our software into a product that matches your requirements. We guarantee a response.

I'm Sold... What's next?

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.