Transactional Replication for Reporting DB Server and Archival of Data

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Transactional Replication for Reporting DB...

Transactional Replication for Reporting DB Server and Archival of Data

Rate Topic

Display Mode

Topic Options

Author

Message

reddyk

Posted Thursday, September 27, 2012 8:50 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 20, 2013 8:45 AM
Points: 174, Visits: 268

We are planning to have a reporting server where data is replicated using transactional replication from production server. If I plan to disable deletes to the subsciber.

Can weuse the subscriber databse for archival purposes also? Would creating a snapshot be an issue? Can the subscriber database have more data than publisher?

Any input is greatly apprecited.

Thanks

Post #1365321

irobertson

Posted Tuesday, October 23, 2012 3:31 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:26 AM
Points: 210, Visits: 575

This doesn't look like a situation where I would use replication. You may be better off setting up SSIS packages to transfer the data that you need.

Post #1375932

Chris Becker

Posted Thursday, December 06, 2012 5:39 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, February 22, 2013 11:49 AM
Points: 220, Visits: 216

There is a feature called 'deferred update' in that an update to a column in a clustered index will replicate as a delete/insert pair.

Build an archive routine that moves rows out of 1 db to another arc db.

regards,
chris
mssqlconsulting.com

Post #1393809

« Prev Topic | Next Topic »

Permissions