Post reply

How to manage common tasks

  • May 11, 2012 at 8:26 am

    #256299

    We have multiple databases installed at mutilple customer sites. But we do not have all databases at all sites. but there are some db objects common to all databases. what is the best way to handle the common db objects?

    thanks for your help in advace.

  • May 11, 2012 at 9:06 am

    #1486375

    joe

    you really need to give us more information

    do you have a network connection between the sites ? - how do you know which sites have db servers - how do you know which items are core?

    and many more questions - we can't see your infrastructure so please describe it for us

    MVDBA

  • May 11, 2012 at 1:18 pm

    #1486583

    there are not network connections between DB servers.

    we have 10 user databases (kind of 10 Products, each using a DB). But we do not install them all in a customer site.

    Some customer may have 2 of 10DBs, some may have 5 of 10DBs. But there are some tables/SPs common to some of DBs. for example DB1 may have SP1. But the SP1 may be requried by 4 other DBs. How to make the SP1 be available in those 4 DBs.

    hope this helps.

    thanks

  • May 12, 2012 at 11:09 am

    #1486774

    Without network connections between the sites, it would seem that emailing the scripts to build the procs is going to be the only way.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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