Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Replication Expand / Collapse
Author
Message
Posted Friday, December 13, 2013 7:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 13, 2013 8:06 AM
Points: 1, Visits: 2
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
Post #1522700
Posted Friday, December 13, 2013 7:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:47 PM
Points: 2,107, Visits: 3,584
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
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Post #1522703
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse