Post reply

Data Replication - Pushing updates

  • October 26, 2007 at 8:34 am

    #183157

    Guys,

    I have 14 databases, the last database - 14th one will have lookup tables only. The other 13 databases will have these lookup tables and data tables. At the end of each day I will make updates for lookup tables on 14th database, I want to be able to push the updates to any or some of the 13 databases. Look up tables will have only upto 100 rows, so I am not concerned about the bandwidth. What is the best way to accomplish this.

    Any suggestions and inputs would help

    Thanks

  • October 30, 2007 at 3:19 am

    #746527

    Hi,

    Create a transactional or snapshot (if you have scope) publication on database 14 and include the lookup tables as your published articles. Once this is done, on each of the 13 databases, create a subscription to publication (push or pull) and you're done.

    Cheers,

    Phillip Cox

  • October 30, 2007 at 3:42 am

    #746541

    i agree with Phillip Cox

  • October 30, 2007 at 1:06 pm

    #746831

    If the databases are on the Same server I would use "SYNONIMS" instead.


    * Noel

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

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