February 4, 2017 at 11:32 am
Comments posted to this topic are about the item Create and Connect to an Azure SQL Database
Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba
February 6, 2017 at 9:07 am
Thanks for the Article. Do you think this approach, Connect to Azure Sql Database over the internet, could be used as a primary backend database for a production .net program running on a windows desktop?
I.E. The program is running on the desktop but connecting to the Azure Database via ADO.Net.
Or is the latency too much?
I know I would have to test but if the Azure Database Connection is not intended for remote apps the I need not try.
TIA, Don
February 7, 2017 at 6:39 am
riversoft - Monday, February 6, 2017 9:07 AMThanks for the Article. Do you think this approach, Connect to Azure Sql Database over the internet, could be used as a primary backend database for a production .net program running on a windows desktop?
I.E. The program is running on the desktop but connecting to the Azure Database via ADO.Net.
Or is the latency too much?
I know I would have to test but if the Azure Database Connection is not intended for remote apps the I need not try.TIA, Don
riversoft - Your approach would depend on a number of different factors. For example, the desktops connection (hard-wired or wireless), connection speed, what function is the desktop application performing, and a number of other factors. I say from an administrative perspective that I've had no issues performing tasks on my SQL Azure databases remotely via Powershell and SSMS. My suggestion would be to test your application's performance (creating benchmarks and user tests) before you deploy to production.
Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply