IDacCompatibilityService Interface

 

Provides a COM service that supports similar actions to the DacServices API. The key difference is that the API is actually a wrapper on SqlPackage.exe, and that it is not bound to a particular version of DacFx or SQL. It will detect the highest installed version on disk and run commands using that version. Note that all inputs must be compatible with the SqlPackage.exe specification. This specifies a number of parameters for each action (some required, some optional), optional properties that can be defined, and for some actions supports specifying SQLCMD variables as inputs. For further information on what is and is not supported please review the SqlPackage.exe documentation on MSDN.

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

Syntax

[ComVisibleAttribute(true)]
[GuidAttribute("D62E6F16-A836-42D0-8353-4FFE439057CA")]
[InterfaceTypeAttribute(ComInterfaceType.InterfaceIsIUnknown)]
public interface IDacCompatibilityService
[ComVisibleAttribute(true)]
[GuidAttribute("D62E6F16-A836-42D0-8353-4FFE439057CA")]
[InterfaceTypeAttribute(ComInterfaceType::InterfaceIsIUnknown)]
public interface class IDacCompatibilityService
[<ComVisibleAttribute(true)>]
[<GuidAttribute("D62E6F16-A836-42D0-8353-4FFE439057CA")>]
[<InterfaceTypeAttribute(ComInterfaceType.InterfaceIsIUnknown)>]
type IDacCompatibilityService = interface end
<ComVisibleAttribute(True)>
<GuidAttribute("D62E6F16-A836-42D0-8353-4FFE439057CA")>
<InterfaceTypeAttribute(ComInterfaceType.InterfaceIsIUnknown)>
Public Interface IDacCompatibilityService

Methods

Name Description
System_CAPS_pubmethod Cancel()

Attempts to cancel the currently running operation.

System_CAPS_pubmethod GetAllValidSqlPackagePaths()

Looks up the valid SqlPackage paths found on disk and returns these to the caller. This is useful for diagnostic purposes.

System_CAPS_pubmethod RunAction(String, IDictionary, IDictionary, IDictionary)

Runs the specified Action.

System_CAPS_pubmethod SetSqlPackagePathToUse(String)

Sets a specific path to a SqlPackage.exe file. This will be used instead of the standard best match found by querying the registry for installed DacFx locations on disk.

See Also

Microsoft.SqlServer.Dac.Compatibility Namespace

Return to top