CRM in house - SQL via Azure

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?
pdesjardins1Asked:
Who is Participating?
 
Aaron TomoskySD-WAN SimplifiedCommented:
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.
0
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
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.
0
 
David Johnson, CD, MVPOwnerCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.