CAUG Oct 2014

Access with SQL Azure

http://www.caug.com/caugtalk-2014-10-AccAzure.html

Overview

• Goal - host DB backend from web
• Result
• Demo
• Future

The Tools:

• SQL Server Migration Assistant for Access, v6.0
• SQL Server Management Studio
• SQLCMD Utility

Future:

• explore backup options
• learn about Trusted Connection, Encryption option for DSN

• explore user/role management options
• setup CNAME for server

FMS Inc. links that go me started:

• 2010 FMSInc blog post that first got me started on this
• Microsoft Azure and Cloud Computing...What it Means to Me and Information Workers
• Microsoft Access and Cloud Computing with SQL Azure Databases (Linking to SQL Server Tables in the Cloud)

Other Microsoft links:

• Guidelines for Connecting to Azure SQL Database
• SQL Azure pricing
• Azure SQL Database General Guidelines and Limitations
• Migrating Access Data into SQL Server/Azure SQL DB (AccessToSQL)
• SQL Azure firewall explained
• Manage Azure via sqlcmd
• How to: Use Integration Services to Migrate a Database to Azure SQL Database

Other SQL Azure/Access links:

• SQL Azure wikipedia page
• Blog post on setting up CNAME for server