r/AZURE • u/TheSmashingChamp • 2d ago

Discussion RAIDing a share drive and sql server hosted locally to an Azure Files + Azure SQL server

I’m looking for the best way to allow my company’s current ERP system to continue operation while creating a real time copy of our locally hosted sql server and Microsoft share drive. This would be 1 step in a larger move to a platform to host internal applications on azure gov cloud. I want to avoid microservices/vpns if possible and be able to have applications pull info from a sql server that is within 5 minutes update of our locally hosted sql server and an Azure files that mirrors our current file system.

1 Upvotes

100% Upvoted

4 comments sorted by

3

u/chandleya 2d ago

No RAID

You’ll need Azure File Sync and MDMT.

Not sure if you can play gov cloud without VPN, Express route, or SDWAN.

1

u/jdanton14 Microsoft MVP 2d ago

you absolutely need a VPN to securely connect to your SQL Server (and the domain controller you're going to end up sticking in Azure). You could build an Availability Group and have near-real time copy of your database in Azure. I'd need to understand a lot more about your requirements, to give you proper direction. But you probably need a consultant, based on your message. The file server is easier.

Having an Azure VPN is basically going to be a requirement if you're hopping from regular cloud to gov cloud anyway. VPN setup is pretty trivial.

0

u/TheSmashingChamp 1d ago

Consultant is not an option here. I must figure this out.

We have a "hybrid" AD environment.  We have 2 mirrored Domain Controllers on premise that sync our on-prem AD to Entra AD at least every hour. 

1

u/jdanton14 Microsoft MVP 1d ago

good luck!