February 17, 2014 at 8:41 am
I am looking for ideas about how to update a SQL 2012 DB that is hosted off-site with a SQL DB that is running locally. This is a situation where the updates are one-way, local to remote.
Thanks.
February 17, 2014 at 8:45 am
How much data needs to be updated?
Does it need to be a continuous process, or is it a one-off?
What kind of bandwidth do you have between the sites?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 17, 2014 at 8:58 am
Very small amounts of data. Im just looking to update around 40 fields total in 3 tables. Yes, it should be continuous. Update remote as changes are made locally. No more than 100 updates per day. There is approximately 30 mb of bandwidth up and down between the sites.
Thanks.
February 17, 2014 at 9:00 am
Transactional replication would most likely work well for you.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 17, 2014 at 9:48 am
OK, thanks. I'll look into that.
February 17, 2014 at 9:51 am
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply