Solved

SQL Proxy Server in simple terms

Posted on 2014-04-01
2
518 Views
Last Modified: 2014-11-12
Hello All

This is WAY out of my comfort area so I was hoping someone could explain how this works in easy terms.

We have an SQL server behind our firewall.  On that server are SQL tables we need to replicate to the cloud server we are setting up.

We tried setting up replication and because it was not set up properly the SQL server's logs filled up and the server basically stopped running.

I was told by someone that a better way would be to set up a proxy server also behind the firewall and have the cloud server replicate with the proxy.  My question is how does the data get from the main server to the proxy server?  Does the proxy server pull the data or does the main server push the data?  The goal is to have nothing mess with the main server because that is the production server.

Ideally what I envision (and like I said I know very little) is that a proxy server pulls the data over (so the main server really is not doing anything) and that the server on the cloud connects thru our firewall on port 1433 (which is set to only accept the proxy's IP and the cloud server's IP)

Can anyone shed light on this?

THANK YOU!
0
Comment
Question by:alevin16
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 39970557
We have done one similar scenario where we used Transactional Replication from one PCI production SQL 2008 R2 database (Publisher/Distribution) to a SQL 2012 database in the DMZ and from there we used the new SQL 2012 "Microsoft Sync Framework" http://msdn.microsoft.com/library/bb726002(v=SQL.110).aspx 
to a SQL Azure (not local cloud) database.

Please see details at:

"Using Multiple Versions of SQL Server in a Replication Topology"
http://msdn.microsoft.com/en-us/library/ms143241.aspx

And more important: "How to: Configure and Execute Synchronization with SQL Azure"

"...how to use the SQL Azure database as an intermediary database to synchronize data from an on-premise SQL Server database to the Web and from the Web to a SQL Server Compact client database. "

http://msdn.microsoft.com/en-US/library/ff928617.aspx
http://msdn.microsoft.com/en-US/library/ff928514.aspx
0
 

Author Comment

by:alevin16
ID: 39971014
Thank you very much for the information.  I am going to check this out to see if I can make sense of it.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Previously, on our Nano Server Deployment series, we've created a new nano server image and deployed it on a physical server in part 2. Now we will go through configuration.
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

734 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