CRM in house - SQL via Azure

pdesjardins1
pdesjardins1 used Ask the Experts™
on
Hello,

Currently i have an in house MS CRM server. The database for this CRM is on an in house SQL server.
I am looking to move things out to 'the cloud.'

I have some MS people telling me that we could take the SQL database and run it off of Azure out in the cloud.

Sounds great on paper...but is there anyone out there currently doing this?
If so: pros, cons, lessons learned???

Anyone out there with an in house CRM server and the database for this server out in the cloud on Azure?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Director of Solutions Consulting
Commented:
Generally the rule is to keep the db close to the server. Having one one premise and one in the cloud seems odd. Not only do you add complexity and slow things down, but you are now reliant on two things as well as the Internet for your system to work.
If you want to make a big change, I'd suggest moving to cloud servers, or just use hosted Microsoft crm.
Rikin ShahMicrosoft Dynamics CRM Consultant
Commented:
Hi,

We also had a situation like our app server was in Asia and Azure server was in US. The issue was whenever a request is raised from CRM it would travel from Asia to US and back to Asia for a single request. This created performance overhead.
Top Expert 2016
Commented:
We also had a situation like our app server was in Asia and Azure server was in US You could have used geo-redundancy (I know it costs more) paying attention to where your sql database is and where the server is. (you can locate them anywhere in the world)

If so: pros, cons, lessons learned??? Guaranteed Uptime.. but you are dependant on your internet being always on. You can replicate to SQL Azure in case of disaster in your DC

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial