Redgate compare settings
Published 21 July 2023
These are the settings relating to database comparisons and deployment script generation.
Elements
Name | Required? | Type | Description |
|---|---|---|---|
filterFile | Yes | String | The path to your Redgate filter file By default, we use Filter.rgf or Filter.scpf in the project folder |
schemaModelFormat | No | String | The format of your schema model |
staticDataTables | No | Static data tables array | Tables to track static data for |
sqlServerSettings | No | SQL Server settings table | SQL Server comparison settings |
oracleSettings | No | Oracle settings table | Oracle comparison settings |
Static data tables
Name | Required? | Type | Description |
|---|---|---|---|
table | Yes | String | The name of the table to track static data for |
schema | No | String | The schema this table lives in |
excludedColumns | No | String array | Columns to exclude tracking static data for |
Example
[redgateCompare] filterFile = "filter.rgf" [redgateCompare.sqlserver] filterFile = "Filter.scpf" [[redgateCompare.staticDataTables]] schema = "dbo" table = "foo" excludedColumns = ["x", "y"] [[redgateCompare.staticDataTables]] schema = "dbo" table = "bar"
