Richard Horne
Member
- Local time
- Today, 10:53
- Joined
- Oct 15, 2020
- Messages
- 55
We use an internally-developed database system that utilises a MySQL back-end running from a server running XAMPP, connected to a Microsoft Access front-end using ODBC that runs locally from every user's computer.
We are looking to move away from the typical Microsoft Server 2012 Active Directory network to an online Azure Active Directory and Sharepoint system. I am trying to determine the best way to host our database and ensure that the connection speed is fast and snappy but also secure and locked down.
I can run the MySQL database from a web-host, but I have security concerns with opening the database up to the internet like that and wondered if there was a better solution?
Could this easily be migrated to MSSQL, SQL, Azure SQL or something else? What's the typical best approach for this scenario?
We are looking to move away from the typical Microsoft Server 2012 Active Directory network to an online Azure Active Directory and Sharepoint system. I am trying to determine the best way to host our database and ensure that the connection speed is fast and snappy but also secure and locked down.
I can run the MySQL database from a web-host, but I have security concerns with opening the database up to the internet like that and wondered if there was a better solution?
Could this easily be migrated to MSSQL, SQL, Azure SQL or something else? What's the typical best approach for this scenario?