How to Manage SQL Server Database Objects
How to manage SQL Server database objects during project development and maintenance.
For example, how to record developers' modifications to table structures, stored procedures, functions, views, etc.
Here are a few ideas, some of which I have never practiced:
1.Sourcecode management tools such as VSS.
The currently commonly used method is consistent with code management and can control version changes, content changes, rollbacks, etc.
All database changes must be strictly based on updating the SourceCode first and then updating the database.
Disadvantages: Modifications made directly on the database cannot be recorded. It can be used to assist users in logging in, modifying and other necessary security permission settings to avoid this.
2.DDL triggers after SQL 2005.
Create a table in the database and use DDL triggers to record changes in user database operations.
All user changes are logged to the database.
Disadvantages: In the case of frequent updates, DDL triggers may affect the performance of the database. You can select the database idle period and reduce the performance impact of DDL triggers on the database through batch changes.