CAUG Sep 2016

Access 2016 with Azure SQL Database V12

http://www.caug.com/caug-2016-09-Acc2016AzureSQL.html

What it takes:

• Access 2016: Access 2016 Retail or Office 365 ProPlus, Office 365 Enterprise E3 (& up).
• Microsoft Azure: Azure portal. Free trial versions have been replaced by $200 credit.

Working with Acc2016 + Azure SQL DBs:

• Run Access 2016 in a virtualized environment to protect your Access 2013 and older evironment. See MS Support article: Install and use different versions of Office on the same PC

• Windows virtualization: Hyper-V
• VirtualBox
• Virtualized application environment: App-V

• Way to move your current data from Access to Azure: SQL Server Migration Assistant for Access, v6.0
• Connnecting Access 2016 to SQL Azure

• ODBC Data Source manager - beware of 32-bit and 64-bit versions (MS KB 942976)
• connectionstrings.com

• Tool to manage your Azure backend: SQL Server Management Studio.

• Included in SQL Server Express Edition past and present editions.
• See FMS comparison matrix to pick the version for you.

• Dealing with backups/restores

• Azure portal Restore to point in time
• Make full backup using SSMS
• Backup to Azure storage Blob
• Make a copy of the database in the Azure portal