[AccessD] Article: "How to ‘Hybridize’ your MS Access Database In Office 365 Azure Database"

Hi Shamil

Thanks for those links. Very useful info.

One interesting point is - as I understand it - that even though a database in Azure SQL Server is quite cheap, it comes included for no additional fee if serving as a backend for Access running under an Office 365 subscription. Further, as MS has announced "unlimited storage" for Office 365 subscriptions you may wonder if that could include databases of unlimited size too - within the limits of SQL Server.

/gustav

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Salakhetdinov Shamil
Sendt: 6. november 2014 01:38
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] Article: "How to ‘Hybridize’ your MS Access Database In Office 365 Azure Database"

 Hi Gustav --

I have got connected MS SQL Server 2012 Management Studio to my Azure SQL database (created via Office 365/SharePoint Access Application) without 'crazy message about sp_set_firewall_rule...' - when connecting database name has to be provided. Now I can see what this Azure SQL is: it has special naming conventions with all objects prefixes with 'Access.' string. It also has special metadata tables, views, stored procedures, UDFs....

Thank you.

-- Shamil

Thu, 06 Nov 2014 01:55:54 +0300 from Salakhetdinov Shamil <mcp2004 at mail.ru>:
>Hi Gustav --
>
>AFAIU Sharepoint uses Azure SQL Databases. Yes, you can migrate normal SQL Server database to Sharepoint (Azure SQL Database) for the use as the backend to an Access desktop frontend. But there are some limitations. Here is a set of links describing migration process(es) and limitations:
>
>Comparison of SQL Server with Azure SQL Database 
>http://social.technet.microsoft.com/wiki/contents/articles/996.comparis
>on-of-sql-server-with-azure-sql-database.aspx
>
>Migrating Databases to Azure SQL Database 
>http://msdn.microsoft.com/en-us/library/azure/ee730904.aspx
>How to: Use the SQL Database Migration Wizard 
>http://msdn.microsoft.com/en-us/library/azure/jj156144.aspx
>Azure SQL Database Transact-SQL Support 
>http://msdn.microsoft.com/library/azure/ee336250.aspx
>Azure SQL Database Tools and Utilities Support 
>http://msdn.microsoft.com/library/azure/ee621784.aspx
>I have tried to connect to the Azure SQL database from MS SQL Server Management Studio 2012 but I have failed:
>
>"Cannot connect to {SQLAzureServerCode}.database.windows.net
>Additional Information:
>Cannot open server '{SQLAzureServerCode}' requested by the login. 
>Client with IP address 'xxx.xxx.xxx.xxx' is not allowed to access the server.
>To enabled access, use the Windows Azure Management portal or run 
>sp_set_firewall_rule on the master database to create a firewall rule 
>for this IP address or address range. It may take up to five minutes for this change to take effect.
>Login failed for user '{UserName}'. This session has been assigned a tracing ID of '{tracingId}'.
>Provide this tracing ID to customer support when you need assistance. (Microsoft SQL Server, Error 40615)"
>
>When I tried to execute sp_set_firewall_rule I have found that SQL Server 2012 master db doesn't have it - I have to install MS SQL Server 2014 (Express)....
>
>Thank you. -- Shamil
>
>Wed, 5 Nov 2014 21:33:39 +0000 from Gustav Brock < gustav at cactus.dk >:
>>Hi Shamil
>>
>>I haven't done so but it looks interesting as the web based Access apps are so limited. This could be the best of both worlds regarding Access desktop applications.
>>
>>A simpler option is, of course and also noted in one of the comments to the article, to use a "clean" SQL Server account on Azure. 
>>
>>By the way, can an existing database from a normal SQL Server be exported to SharePoint for the use as the backend to an Access desktop frontend?
>>
>>/gustav
>>
>>________________________________________
>>Fra:  accessd-bounces at databaseadvisors.com <  
>>accessd-bounces at databaseadvisors.com > på vegne af Salakhetdinov 
>>Shamil <  mcp2004 at mail.ru >
>>Sendt: 5. november 2014 21:01
>>Til: Access Developers discussion and problem solving
>>Emne: [AccessD] Article: "How to ‘Hybridize’ your MS Access Database In Office 365 Azure Database"
>>
>> Hi All --
>>
>>Does anybody use "hybrid" MS Access FE/SQL Azure BE (Office 365) applications in production?
>>
>>"How to ‘Hybridize’ your MS Access Database In Office 365 Azure Database"
>> 
>>http://www.devhut.net/2014/01/13/how-to-hybridize-your-ms-access-database-in-office-365-azure-database/
>>
>>I have just followed the referred article's instructions using my Office 365 dev account and I have got a sample "hybrid" database up& running.
>>And MS Access 2013 .accdb bound forms have read-write access to the linked via 'ODBC;DRIVER=SQL Server Native Client 11.0;'  SQL Azure database tables.
>>I wonder if such .accdb forms can be bound to SQL Azure insert/update/delete stored procedures?
>>
>>FYI: Here is a good set of information on SQL Azure and MS Access:
>>
>> http://gainingaccess.net/SQLAzure/AccessAndSQLAzureLinks.aspx
>>
>>
>>Thank you.
>>
>>--
>>Салахетдинов Шамиль