Post reply

Mirroring Tables

  • December 17, 2007 at 8:36 pm

    #181382

    Hi guys,

    Is it possible to mirror selected tables from one database to another database? Basically what I have is this two database; Database B uses all of the look up tables and some parent tables on Database A.

    My initial plan was to use those tables from Database A on JOINS referencing them by dbname then the table name (for ex DatabaseA..TableA). But I was having doubts whether this could cause performance impact on both database.

    So my other plan was to copy the tables to be referenced to Database B, but the problem is some of the tables are being updated from time to time in Database A.

    Or you have better suggestion on my scenario.

    Thanks in advance!

  • December 17, 2007 at 9:05 pm

    #760891

    Sounds like you'd be better off using replication. Have a look at transactional publications with updating subscriptions.

    --------------------
    Colt 45 - the original point and click interface

  • December 17, 2007 at 10:06 pm

    #760898

    Hi

    Replication it is or u can use SSIS for doing data transfer if that is applicable in your situation. Iam assuming that since they are lookup tables data changes in these tables will be less frequent.

    "Keep Trying"

  • December 17, 2007 at 10:46 pm

    #760901

    Thanks guys for giving me a headstart!

    I'll go check replications. Thanks!

Viewing 4 posts - 1 through 3 (of 3 total)

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