Solved

Microsoft SQL Cloud Replication

Posted on 2014-04-24
15
732 Views
Last Modified: 2014-11-12
I need the ability to replicate our sql data to the cloud.  I see google has one, but it is mysql.  Amazon has one, but I doesn’t offer replication services.  I tried a simple GoDaddy hosting account, no go.

Any recommendations?
0
Comment
Question by:dzirkelb
  • 5
  • 4
  • 4
  • +1
15 Comments
 
LVL 15

Expert Comment

by:Ess Kay
ID: 40021276
awardspace
0
 
LVL 8

Expert Comment

by:ProjectChampion
ID: 40021884
I would choose Azure.
0
 
LVL 32

Expert Comment

by:shalomc
ID: 40022087
You still need replication tools on your premises. The steps would be:

a. Setup the SQL environment in the cloud (I recommend Amazon over Azure)
b. Setup the replication tools in your private environment.
c. Setup your network to allow the required outgoing connections

Amazon does not offer replication services, because you already have replication services built-in inside SQL server, and they can be used with an Amazon SQL instance.

Depending on your needs, you may use something like this
http://www.cloudberrylab.com/amazon-s3-sql-backup.aspx

Or tools like these
http://msdn.microsoft.com/en-us/library/ms151198.aspx
0
 
LVL 8

Expert Comment

by:ProjectChampion
ID: 40022175
Re:
>>a. Setup the SQL environment in the cloud (I recommend Amazon over Azure)
>>b. Setup the replication tools in your private environment.

That's exactly why I'd use Azure, because assuming you're already using SQL Server and Visual Studio in your development platform, with Azure (a) and (b) are almost resolved out of the box or need minimal effort and the integration with the rest of the development tools and platform will be seamless.

More importantly with Azure (the last time I checked) you can setup and test the solution for free before committing to make any purchase.
0
 

Author Comment

by:dzirkelb
ID: 40022472
What I'm looking to do is essentially just connect to the cloud sql server with management studio, and replicate data to it.  Then, in the event of a disaster, grab that data back and query it when needed.  I'll take a look at Azure and get back to you, thanks.
0
 

Author Comment

by:dzirkelb
ID: 40022489
Azure looks like exactly what I'm looking for, but that price is way too hefty for what I want to pay.  I'm looking to pay 50 dollars a month or so.  Azure offers so much stuff that jacks up the price for what we don't need.

As an fyi, we are upgrading our WAN, and will set up replication between two locations myself for the long term, but for the short term, I was looking for a quick fix, maybe a 3-6 month solution.  Maybe that will help a little bit in describing what I'm looking for, aka, cheap.
0
 
LVL 15

Expert Comment

by:Ess Kay
ID: 40022578
for free, use this
http://sqlbackupandftp.com/

you can get a server at awardspace with unlimited bandwith and space for about 5/mo
0
Shouldn't all users have the same email signature?

You wouldn't let your users design their own business cards, would you? So, why do you let them design their own email signatures? Think of the damage they could be doing to your brand reputation! Choose the easy way to manage set up and add email signatures for all users.

 
LVL 32

Expert Comment

by:shalomc
ID: 40022590
http://calculator.s3.amazonaws.com/index.html#key=calc-6C2466D7-9058-4457-A881-85655F505455&r=IAD&s=EC2

a Micro instance with Windows and Web SQL server, 50GB storage will cost ya $52/month

RDS is free for a year, but does not support replication :(

I skipped the optional snapshots, backup storage, private AMI etc, although in real life I highly recommend looking at a cloud environment as more than a place to run virtual servers.
0
 

Author Comment

by:dzirkelb
ID: 40022607
I thought Amazon sql server cloud storage didn't support replication?

sqlbackupandftp is a backup solution from what it looks like, not a replication service.
0
 
LVL 32

Expert Comment

by:shalomc
ID: 40022630
Amazon have 2 flavors of SQL:

* RDS is Database as a Service. It does very well its own internal replication and HA but cannot be used with external databases.

* Run SQL on your own windows server. When you do it, on the one hand you are now fully responsible for the server management, but on the other hand gain full flexibilty just likean in-house server in your dc.
0
 

Author Comment

by:dzirkelb
ID: 40022645
I already have SQL running on my own windows server, and I need to replicate it's data to the cloud.  So, looks like Amazon is out, correct?

If there aren't any out there for cheap, then so be it, we wait 3 months for our own cloud.
0
 
LVL 8

Expert Comment

by:ProjectChampion
ID: 40022686
We have our own cloud these days, but prior to that I used RackSpace for a cloud-based SQL Server for a while and setup replication between that server and our physical infrastructure. I can't remember their price though as it was quite a while ago and it has surely changed since then anyway.

Effort-wise it took me the best part of a day to setup SQL Server from scratch, setup security and FW, migrate the data and setup replications (two-way transactional) but after that it was fairly hassle-free.
Maybe it's worth checking their prices.
0
 

Author Comment

by:dzirkelb
ID: 40022706
Looks like Rackspace only offers MySQL databases.

I'd rather not go the route of creating a full-blown virtual server, as I'm sure I'd have to license a server 2013 install, along with a sql 2012 install
0
 
LVL 8

Expert Comment

by:ProjectChampion
ID: 40022764
Perhaps it's changed recently. They definitely used to provide MS SQL Server in the past. Wish I could be of more help...
Good luck with your project and let us know if you find a solution, it'll surely be useful for others in the community.
0
 
LVL 32

Accepted Solution

by:
shalomc earned 500 total points
ID: 40022825
lol, I was not clear in my answer.

" Run SQL on your own windows server." - your own virtual instance running in the amazon cloud.

You don't have to acquire any licenses, you just pay per hour.

Cheers
0

Featured Post

The curse of the end user strikes again      

You’ve updated all your end user’s email signatures. Hooray! But guess what? They’re playing around with the HTML, adding stupid taglines and ruining the imagery. Find out how you can save your signatures from end users today.

Join & Write a Comment

Suggested Solutions

Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

757 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

20 Experts available now in Live!

Get 1:1 Help Now