Welcome to Sign in | Join | Help
in Search

Modificare baza de date

Last post 04-04-2012, 1:19 PM by Diana. 2 replies.
Sort Posts: Previous Next
  •  04-04-2012, 7:48 AM 9195

    Modificare baza de date

    Am o aplicatie distribuita la 10 puncte de lucru.
    Am modificat 10 proceduri stocate, am sters 5 si am modificat 5, pe serverul unde dezvolt aplicatia.

    Vrea sa fac actualizarile automat pt a evita erorile. Cum se face de obicei ? Un script ?
    Un link eventual.

  •  04-04-2012, 10:50 AM 9196 in reply to 9195

    Re: Modificare baza de date

  •  04-04-2012, 1:19 PM 9197 in reply to 9195

    Re: Modificare baza de date

    Local Server Groups:
    http://www.mssqltips.com/sqlservertip/2086/run-sql-commands-against-multiple-sql-servers-without-cms/

    Central Management Servers:
    http://www.mssqltips.com/sqlservertip/1767/execute-sql-server-query-on-multiple-servers-at-the-same-time/

    sp_MSforeachdb:
    http://www.mssqltips.com/sqlservertip/1414/run-same-command-on-all-sql-server-databases-without-cursors/

    SQLCMD mode:
    http://www.mssqltips.com/sqlservertip/2311/using-the-ssms-query-editor-in-sqlcmd-mode/

    Powershell - scurt filmuletz (~15 min) care merita downlodat si urmarit:
    http://midnightdba.itbookworm.com/VidPages/PowershellReplaceMSForEachDB/PowershellReplaceMSForEachDB.aspx
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems