![]() When any DDL change occurs in a database, the add-in will write the information in this table, including when/who made a change, against what object, and a T-SQL statement executed before the change:ĪpexSQL_SourceControl_DDLTrigger – DDL trigger used to catch all DDL changes that will be written in the ApexSQL_SourceControl_DatabaseLog table:ĪpexSQL_SourceControl_FrameworkVersion – a function used for upgrading the framework objects when needed: When linking a database using the dedicated development model, the following SQL inventory system objects will be created in the linked database under the dbo schema for SQL Server and Amazon RDS for SQL Server:ĪpexSQL_SourceControl_DatabaseLog – system table used to store all information about any change made against the source-controlled database objects. Minimal permissions for Amazon RDS in database source control.Minimal permissions for Azure SQL Database in database source control.Minimum permissions required to work with ApexSQL Source Control.More on the needed permissions can be found in the following articles: To link a database to a source control repository based on the chosen Server, some additional permissions will be needed. This article gives an overview of the SQL inventory system objects (called framework objects) that ApexSQL Source Control creates on the initial database linking to a source control repository
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |