July 31, 2015 at 10:19 am
Our organization is finally venturing down the world of having a public web presence and we're in the process of figuring out how to duplicate our live data to keep the site from accessing it directly.
We are planning to use SSIS packages to retrieve internal data from random sources and transform it into usable SQL data on a server internal to the network. Then some sort of copy will happen on a set schedule to send that data to the sql server sitting in the isolated web environment for the website to call.
Where I'm getting stumped at designing this setup is since this data is being refreshed say twice a day how do I manage to keep the database online for the website users to call while the newest copy is being sent over.
Is there something in sql that handles this or is another product or tool required?
Server 2012 R2, SQL 2014
Thanks.
July 31, 2015 at 10:30 am
You could look into the possibility of using snapshots or synonyms.
Snapshots would essential hold a static copy of your data while you're ding your updates.
Synonyms could be used to switch between to copies of your table and would direct queries to the most up to date version of your data.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 31, 2015 at 10:49 am
Alvin Ramard (7/31/2015)
You could look into the possibility of using snapshots or synonyms.Snapshots would essential hold a static copy of your data while you're ding your updates.
Synonyms could be used to switch between to copies of your table and would direct queries to the most up to date version of your data.
Thank you Alvin. I will start researching both of these concepts. I typed all kinds of strings in google trying to get something but snapshots and synonyms for some reason never came up.
Does this sound like a solid plan to you for keeping outside traffic away from our live data? I'm very open to suggestions since this is very new to me. Thanks again for the reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply