December 13, 2013 at 7:51 am
Hi, I am using Sql server 2005. I have a database for one of the application and I need to use another Database for reporting(Replication). Could you please suggest me how to replicate the database.I would like to replicate the database for every 5 mins. Suggest me whether this will be good idea or any other suggestions?
Sri
December 13, 2013 at 7:54 am
It is a fine idea and a frequently used solution. I would recommend that you use transactional replication. To begin you will need to figure out what tables are needed for reporting (assuming it is not all) and then do some reading on configuring replication. Shout back if you have questions.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply