June 24, 2014 at 1:54 pm
We have an application (called Umbraco) hosted on Azure. We also have an on-premises SQL Server database. We'd like to integrate the two. Specifically, we want to push or pull data from the on-prem DB to Umbraco's database.
My approach was to use Azure's Data Sync to synchronize my on-prem DB with custom tables I'd add to the Umbraco DB. I would then build a process to poll the tables for changes and then push those changes through Umbraco's API.
My co-worker doesn't like this approach because he doesn't like the idea of constantly polling the tables to find changes. He wants to use a CLR proc in the on-prem DB to call the Umbraco API. I'm concerned about this approach primarily because of security concerns.
Are one of these ideas better? Are there other ideas?
Any help is much appreciated!
Thanks!!
June 24, 2014 at 8:55 pm
As much as you can, I'd try to keep any queries against the SQL database up in the Azure cloud. Any, regardless of if you write them or you use the API, that pull data down locally, are going to be costly. So, if you can create a service or function that does the polling within Azure, you'll be better off.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 25, 2014 at 6:12 am
Thanks Grant! I appreciate the help. So would you say that polling isn't necessarily a bad idea in and of itself?
P.S. Your books have been a huge help! I carry your tuning book in my work bag.
June 25, 2014 at 6:28 am
I wouldn't say polling is bad, no. Not at all. It's one way to get things done. How you poll, where you poll, how often you poll, those are the tougher questions to answer.
And thanks. Glad it's helpful.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply