• Post suggests there are two different issues here.

    1) "Sharing" a table in between different schemas or the same database.

    2) "Sharing" a table in between different databases located in different servers.

    In the first case, I can see no compelling reason to duplicate the "shared" table to every single schema. I would just access the main -unique- "shared" table just by fully qualifying it.

    In the second case, I would go with replication.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.