patternsqlMinor
Read-only copy of SQL Server database
Viewed 0 times
readsqldatabaseserveronlycopy
Problem
We have main database, through out day we insert/update this DB through main application(windows). We have another web application which is suppose to just display content from main DB but instead we have created new DB which we update through out day either manually or from code.
I want to get rid of this manual/code process of updating one DB to another DB. What are the options? Eliminate second DB and just read from main DB? Replication? Mirroring?
It has to be real time update.
Thanks,
I want to get rid of this manual/code process of updating one DB to another DB. What are the options? Eliminate second DB and just read from main DB? Replication? Mirroring?
It has to be real time update.
Thanks,
Solution
You could implementation Replication if there is a subset of data that you are looking to read from. Replication publishes articles to subscribers. It's a great way for a subset of data that needs to be recent data.
If you are looking for a read-only copy of the whole database, though, and the data doesn't need realtime accuracy, you could create snapshots every morning with a job. That way the OLAP can be done against the snapshot. Or if you need the data to be a maximum of 4 hours old you can do that. (or whatever schedule you find the need to "refresh" the data)
If you are looking for a read-only copy of the whole database, though, and the data doesn't need realtime accuracy, you could create snapshots every morning with a job. That way the OLAP can be done against the snapshot. Or if you need the data to be a maximum of 4 hours old you can do that. (or whatever schedule you find the need to "refresh" the data)
Context
StackExchange Database Administrators Q#7142, answer score: 2
Revisions (0)
No revisions yet.