Enable D365SqlChangeTracking - FH-Inway/d365fo.tools GitHub Wiki
Enable Change Tracking for the environment
Enable-D365SqlChangeTracking [[-DatabaseServer] <String>] [[-DatabaseName] <String>] [[-SqlUser] <String>]
[[-SqlPwd] <String>] [-EnableException] [<CommonParameters>]
Enable the SQL Server Change Tracking for the environments database
It is a requirement for the Data Entities refresh to be able to complete correctly
Enable-D365SqlChangeTracking
This will enable the Change Tracking on the Sql Server.
The name of the database server
If on-premises or classic SQL Server, use either short name og Fully Qualified Domain Name (FQDN).
If Azure use the full address to the database server, e.g. server.database.windows.net
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 1
Default value: $Script:DatabaseServer
Accept pipeline input: False
Accept wildcard characters: False
The name of the database
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 2
Default value: $Script:DatabaseName
Accept pipeline input: False
Accept wildcard characters: False
The login name for the SQL Server instance
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 3
Default value: $Script:DatabaseUserName
Accept pipeline input: False
Accept wildcard characters: False
The password for the SQL Server user
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 4
Default value: $Script:DatabaseUserPassword
Accept pipeline input: False
Accept wildcard characters: False
This parameters disables user-friendly warnings and enables the throwing of exceptions This is less user friendly, but allows catching exceptions in calling scripts
Type: SwitchParameter
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
Tags: MaintenanceMode, Maintenance, License, Configuration, Servicing
Author: Mötz Jensen (@splaxi)