UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Migrating Or Storing An Access 2016 Back End Database Schema, Tables, Data To Azure SQL Database, Access 2016    
 
   
AccessQuery
post Jul 12 2018, 12:25 AM
Post#1



Posts: 44
Joined: 9-June 18



Hi Access Forum Group

As I am just exploring Azure as a solution for backend file of Access,
I have asked a few questions in the Microsoft Developer Network.

it is both looking at using an SQL Database a

https://social.msdn.microsoft.com/Forums/en...=ssdsgetstarted


https://social.msdn.microsoft.com/Forums/en...indowsazuredata
nd if even remotely possible using file storage to simply store the access backend, if this is possible
https://docs.microsoft.com/en-us/azure/storage/


I also ran into an issue trying to install SSMA
https://social.msdn.microsoft.com/Forums/en...m=sqldataaccess
but reading on there are issues
https://docs.microsoft.com/en-us/SQL/SSMA/a...SQL-server-2017

I was hoping getting access backend into azure was a bit simpler. If anyone can share any feedback to my questions above,
and tips and tricks. This are is quite new to me.
Thank you kindly
Go to the top of the page
 
AccessQuery
post Jul 15 2018, 11:30 PM
Post#2



Posts: 44
Joined: 9-June 18



Hi UtterAccess

As I am understanding Azure more now, an opinion please

1) A local SQL Server Database is setup as the backend for an access front end (instead of an Access backend file)

2) The Access frontend updates at the same time both the Azure SQL Database and the local SQL Server Database,

(Taking note that the Azure SQL Database is updated live by both the Administrators and the Staff, hence requiring multiple IP's)

3) Instead of using Azure SQL Sync to keep the local SQL Database and the Azure SQL Database synchronised,
that the Administrator toggles to the local database if they wish to say do merely reporting, and using one of the tools on this forum:
http://www.UtterAccess.com/forum/index.php...ween+local+prod


In this manner the local and online copy of data is always sync'ed. And there is less data being synced to the local copy, thus reducing costs.
And the performance for the administrator would be quicker when they wish to merely retrieve information, by working of an up to data local copy.

Now of course we would still need a sync at a less frequent level to the local copy, perhaps on a daily basis, for any changes made by the staff to the Azure SQL Database.

Is such a setup possible, or not practical, or rather logical?

Thank you.

Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    18th July 2018 - 07:22 AM