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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.