• Article

DacUpgradeOptions.IgnoreDrift Property

Note: This API is now obsolete.

Gets and sets the Ignore Drift upgrade option.

Namespace:  Microsoft.SqlServer.Management.Dac
Assembly:  Microsoft.SqlServer.Management.Dac (in Microsoft.SqlServer.Management.Dac.dll)

Syntax

'Declaration
<ObsoleteAttribute("Please use BlockOnChanges")> _
Public Property IgnoreDrift As Boolean
    Get
    Set
'Usage
Dim instance As DacUpgradeOptions
Dim value As Boolean

value = instance.IgnoreDrift

instance.IgnoreDrift = value

[ObsoleteAttribute("Please use BlockOnChanges")]
public bool IgnoreDrift { get; set; }

[ObsoleteAttribute(L"Please use BlockOnChanges")]
public:
property bool IgnoreDrift {
    bool get ();
    void set (bool value);
}

[<ObsoleteAttribute("Please use BlockOnChanges")>]
member IgnoreDrift : bool with get, set

function get IgnoreDrift () : boolean
function set IgnoreDrift (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies what action the upgrade takes if drift is detected. If True, the upgrade will proceed despite finding changes in the database that may cause some data to be missing from the upgraded database. Only specify Ttrue if you have previously analyzed the changes and have a plan in place for migrating the data manually. If False, the upgrade will stop if it detects drift.

Remarks

Drift is marked by changes made to a database after a DAC is deployed, such that the database schema is now different than the original schema defined in the DAC type. If tables have been added or changed, such as by using CREATE TABLE or ALTER TABLE statements, the tables or their data may not be moved to the upgraded database. They will be present in the original database that is preserved by the upgrade, so you can move the data manually. For more information, see Upgrading Data-tier Applications.