Post reply

Alternative ways to replicate data from Huge databases

  • May 12, 2014 at 11:57 pm

    #286609

    We are using Warehouse to show reports to the application user.

    We have 4 Transactional databases from which we replicate the data to Central Repository Database, by using Transactional replication.

    Transactional databases are large in size as have old records (5-6 years old).

    So Central Repository Database became very large near about 200 GB. But we don't require all data in Central Repository Database.

    We require only recently update data from Central Repository Database, to sync with Warehouse.

    We have two solutions

    1) Create SQL server Agent jobs to Move Data between Transactional database and Central Repository Database.

    But this will require data validation overhead and error check.

    2) Use Filtered Transactional Replication based on records AddDate and cleanup Old data from Central Repository Database

    Can anyone give better suggestions ,How can we reduce the size of the Central Repository Database, by using any other alternative way?

    It would be great help.

    Thanks & Regards,

    Abhishek Patidar

  • May 13, 2014 at 9:40 pm

    #1713304

    Is this

    :-Use of Data AddDate / LastModifyDate column filtered transactional replication is the best way to handle such problem of big size Central Repository database

    and delete old data afterward from central repository system which are out of where clause.

    Thank you in advance,

    Abhishek Patidar

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply