Many companies still use Microsoft Access for basic database operations in the office. Access 2010 now connects to SQL Azure which gives perfect opportunity for IT professionals to setup small business Access 2010 databases to interact with the cloud, adding value for the customer to use a familiar database tool and extend business operations into the cloud for added benefit. Some obvious benefits of the cloud is letting Microsoft’s cloud worry about backup and availability, scalability for customers that want to start with a small database but know that in the future they can expand as their company grows, and finally giving down-to-earth small business owners a practical way to get introduced to the benefits of the cloud without jumping off a cliff.
Access 2010 supports SQL Azure through the ODBC connector. The SQL Server Migration Wizard will lets database professionals migrate an existing SQL database to SQL Azure. If you have existing SQL CREATE scripts that you want to run in SQL Azure read my blog post on one modification you will want to make to your scripts, even if you’re using the latest SQL Server Management Studio 2008 R2.
There are different SQL Azure packages to choose from including an Introductory Special that is free if you use under a certain amount, the best way to test how this works.
If you are a business that provides this service of hooking up a SQL Azure account and database for small businesses then feel free to leave your contact information in the comments section. Thanks.