Export (0) Print
Expand All

What's New in SSMA for Access(AccessToSQL)

SQL Server 2012

This topic lists SSMA for Access changes in each release.

The July 2014 release of SSMA for Access contains the following changes:

  1. Improved Azure SQL DB code conversion

  2. Extension pack functionality moved to schema to support Azure SQL DB

  3. Performance improvements tested for databases with over 10k objects

  4. UI improvements for dealing with large number of objects

  5. Highlighting of “well known” LOB schemas (so they can be ignored in conversion)

  6. Conversion speed improvements

  7. Show object counts in UI

  8. Report size reduction by more than 25%

  9. Improved error messages for unparsed constructs.

The April 2014 release of SSMA for Access contains the following changes:

  1. Added support of MS SQL Server 2014.

  2. Fixed bugs regarding conversion to Azure.

  3. Fixed bugs regarding invisible report pages in IE 10.

The January 2012 release of SSMA for Access contains the following changes:

  • Provided the option to not persist username and password for MS Access linked tables after migration.

  • Set cascade actions for circular references to No Action.

  • Provided proper messages indicating cascade actions for circular references have been set to No Action.

The July 2011 release of SSMA for Access contains the following changes:

  • Improved error reporting during data migration.

The April 2011 release of SSMA for Access contains the following changes:

  • Single Installable of “SSMA for Access”, which supports SQL Server 2005, SQL Server 2008, SQL Server “Denali” and SQL Azure.

  • The ability to connect SQL Server “Denali”

  • SSMA for Access Console version supports backward compatibility. You will be able to open the projects created by versions earlier to SSMA v5.0

  • SSMA v5.0 product can be installed side by side (SxS) with older versions of SSMA Product.

The July 2010 release of SSMA for Access contains the following changes:

  • Support for migrating to SQL Server 2008 R2 and SQL Azure

  • Secure connection to both SQL Server and SQL Azure.

  • Support for Access 2010 databases

  • New SSMA Console application for command line execution

  • Support for SQL Server DateTime2 data type

The June 2008 release of SSMA for Access contains the following changes:

  • Support for Access 2007 databases.

The May 2007 release of SSMA for Access contains the following changes:

  • Support for Access databases that use workgroup policies.

  • The ability to delete converted objects from the SQL Server metadata explorer.

  • Support for user-entered comments the SQL Server formatted SQL mode.

  • Improvements in object conversion.

The November 2006 release of SSMA for Access contains the following changes:

  • A new Database Migration Wizard that guides you through the migration of a single database from Access to SQL Server.

  • A new Convert, Load, and Migrate command that converts Access databases, loads the converted objects into SQL Server, and migrates data into SQL Server all in one step.

  • Improved query migration. Query migration now converts more SELECT queries to views. For more information, see Converting Access Database Objects.

  • You can now edit table and index properties on the SQL Server Table tab.

  • New global settings:

    • You can opt to show line numbers in editor windows.

    • You can configure SSMA to prompt to replace duplicate objects, or always or never replace duplicate objects during schema conversion.

  • A new conversion option lets you specify if SSMA displays a warning when a complex query contains a wildcard.

The July 2006 release of SSMA for Access was the initial release.x

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft