Solved

CRM in house - SQL via Azure

Posted on 2014-03-05
3
635 Views
Last Modified: 2014-11-12
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?
0
Comment
Question by:pdesjardins1
3 Comments
 
LVL 38

Accepted Solution

by:
Aaron Tomosky earned 167 total points
ID: 39908462
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
 
LVL 19

Assisted Solution

by:Rikin Shah
Rikin Shah earned 167 total points
ID: 39908477
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
 
LVL 78

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 166 total points
ID: 39908613
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

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now