Leveraging SQL Azure with Microsoft Access - SQL Azure Team Blog - Site Home - MSDN Blogs

Leveraging SQL Azure with Microsoft Access

Leveraging SQL Azure with Microsoft Access

  • Comments 3

SQL Server Migration Assistant (SSMA for Access v4.2) has been updated to support migrating your schema and data from Microsoft Access to SQL Azure. This release makes it possible to move data directly and easily from local Microsoft Access databases. The SQL Server Migration Assistant toolkits were designed to tackle the complex manual process customers deal with when migrating databases. By using the SQL Server Migration Assistants, customers and partners reduce the manual effort; as a result the time, cost and risks associated with migrating are significantly reduced.

You now can “upsize” your data from the Access to the full relational database of SQL Azure. By transitioning from the Access database to SQL Azure (using the migration assistant), with all the benefits of SQL Azure. Best of all, your existing Access application front ends can continue to be used with the data now residing in SQL Azure . Access 2010 can connect transparently to SQL Azure data (via linked tables), opening up opportunities for Access users and technology providers to create rich experiences while leveraging the benefits of the cloud on a “pay as you grow” elastic basis.

For more information on how to use Access 2010 with SQL Azure, please also see the detailed blog that was posted at TechEd which walks through how to get started. This blog is slightly out of date with the new release of SQL Server Migration Assistant; at TechEd it was not possible to move data directly to SQL Azure. We will be following up with updated blog post so stay tuned.

Download for free SSMA for Access v4.2

Summary

Do you have questions, concerns, comments? Post them below and we will try to address them.

  • Wayne - great post and very helpful.  What about the possibility of using SQL Azure with different version of Microsoft Access?  Is it possible, how will the experience differ?  We have a varied client environment here so flexibility is paramount.

  • Drew: On the SSMA download page is says: "SSMA for Access supports migration from Access 97 and higher to any edition of SQL Server"  However, I havn't tried it.

  • Hey Wayne,

    Great information! I really appreciate it....

    I have done all the steps, however I cannot connect my Access front end now to the Azure Database that is hosted? I am using Access 2007....

    Yes, I can make an ODBC connection and that works fine....

    I see the data, tables etc..... up on the hosted Azure site.....

    Just don't know how to get my Access client's front end piece configured....

    thanks for your help,

    don

Page 1 of 1 (3 items)
Leave a Comment
  • Please add 2 and 5 and type the answer here:
  • Post