IDacCompatibilityService Interface

SQL Server 2014
 

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)

<ComVisibleAttribute(True)>
<GuidAttribute("D62E6F16-A836-42D0-8353-4FFE439057CA")>
<InterfaceTypeAttribute(ComInterfaceType.InterfaceIsIUnknown)>
Public Interface IDacCompatibilityService

NameDescription
System_CAPS_pubmethodCancel()

Attempts to cancel the currently running operation.

System_CAPS_pubmethodGetAllValidSqlPackagePaths()

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

System_CAPS_pubmethodRunAction(String, IDictionary, IDictionary, IDictionary)

Runs the specified Action.

System_CAPS_pubmethodSetSqlPackagePathToUse(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.

Return to top

Community Additions

ADD
Show: