Distributing SQL Server Database Installations and Upgrades

  • I am hoping for some guidance on how other companies deploy their database installations and upgrades on a large scale. Do you use any installer products? What have you found helpful? It seems to be a difficult task to handle, we've been attempting to use the custom actions in WiX so far.

    Thanks,

    Dana

  • Probably not the answer you were looking for, but we make our own... most of it is just custom scripting.

    --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)

  • Hi,

    anybody can tell me Why SQL Server 2000 cant install my PC?and my Pc currently running Windows XP Perfesonal. it pop up message "Microsoft SQL Server cant support this Operation System ,only Client component will be avalable for installation". But as for my final project I need a single Server database for my own PC.

    Can anybody help me?! Thank!

    Regard

    Mike

  • The "real" SQL Server requires that it be installed on a Windows SERVER.  The only edition you can install on a non-Windows Server is the "Developers Edition" (same as Enterprise Edition but with different licensing).

    --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)

  • Oh, Thank you advice.(I thought all the SQL Server edition is almost same)

    Thank again!

    Regard

    Mike

  • Oh, Thank you advice.(I thought all the SQL Server edition is almost same

    Thank again!

    Regard

    Mike

Viewing 6 posts - 1 through 5 (of 5 total)

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