Post reply

Replication to a database with more tables than the source

  • April 14, 2015 at 2:29 pm

    #296891

    We need to replicate data from a live database to a reporting database nightly.

    There is data which is only needed for the reporting function - namely the selection criteria for reports which are to be run nightly or monthly.

    Is it possible to have extra tables in the target database, holding the selection criteria?

    If not, we'll have the reports running heterogeneous queries between the target database and a separate database with the selection criteria in it.

  • April 15, 2015 at 1:34 am

    #1791003

    Because Replication only copies data from individual tables (each article is effectively a table) the Subscriber can have additional tables that Replication has no knowledge of.

    We have Subscribers here that receive data from several Publications, each maintaining different tables and unaware of the others. We also have Subscribers that have tables on them that play no part in a Publication.

    Steve Hall
    Linkedin
    Blog Site

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

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