Hi there, Can anyone suggest me how to do patching for MSSQL database please? I have a database that released to a few users and now it needs to be updated such as relationships, stored procedures ,status, tables and schema changes. How can i do that please? Are there software for this MSSQL database ? Regards, Kai
Sure there is third-party software for this available. Just check our Software section here. This might also be interesting for you: http://www.sql-server-performance.com/articles/dba/change_management_p1.aspx http://www.sql-server-performance.com/articles/dba/database_change_management_2_p1.aspx
You can maintain your own version table table within the database so that you can run the script based on the version.