Share via


DependencyWalker Class

The DependencyWalker object is a tool to perform scripting operations that involve dependencies such as identifying dependent relationships. The tool and converts this output to a list.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.DependencyWalker
    Microsoft.SqlServer.Management.Smo.Scripter

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

Syntax

'Declaration
Public Class DependencyWalker
'Usage
Dim instance As DependencyWalker
public class DependencyWalker
public ref class DependencyWalker
type DependencyWalker =  class end
public class DependencyWalker

The DependencyWalker type exposes the following members.

Constructors

  Name Description
Public method DependencyWalker() Initializes a new instance of the DependencyWalker class.
Public method DependencyWalker(Server) Initializes a new instance of the DependencyWalker class on the specified instance of SQL Server.

Top

Properties

  Name Description
Protected property DependencyTree Gets or sets a server dependency tree.
Public property FilterCallbackFunction Gets or sets the scripting options that allow URNs to be filtered out while running the DiscoverDependencies method.
Protected property KnownObjectsList Gets or sets a list of all known objects in a server.
Public property Server Gets or sets the instance of Microsoft SQL Server that the DependencyWalker tool object is associated with.
Protected property Total Gets or sets the number of objects that have been processed by the DependencyWalker object.
Protected property TotalCount Gets or sets the count of objects discovered by a dependency walker.

Top

Methods

  Name Description
Public method DiscoverDependencies(array<SqlSmoObject[], DependencyType) Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified object array of SQL Server objects on the instance of SQL Server.
Public method DiscoverDependencies(array<SqlSmoObject[], Boolean) Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified object array of SQL Server objects on the instance of SQL Server.
Public method DiscoverDependencies(array<Urn[], DependencyType) Creates a hierarchical object tree that represents the parent- or child-dependent relationships for a specified Urn array of SQL Server objects on the instance of SQL Server.
Public method DiscoverDependencies(array<Urn[], Boolean) Creates a hierarchical object tree that represents the parent- or child-dependent relationships for a specified Urn array of SQL Server objects on the instance of SQL Server.
Public method DiscoverDependencies(UrnCollection, DependencyType) Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified Urn collection of SQL Server objects on the instance of SQL Server.
Public method DiscoverDependencies(UrnCollection, Boolean) Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified Urn collection of SQL Server objects on the instance of SQL Server.
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Protected method GetServerObject Returns the Server object that represents the instance of SQL Server on which the dependency discovery operation is running.
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method ToString (Inherited from Object.)
Public method WalkDependencies Creates a linear list of objects and their dependencies from a specified DependencyTree object.

Top

Events

  Name Description
Public event DiscoveryProgress Raises an event at intervals and reports progress on the DiscoveryProgress method.

Top

Remarks

The DependencyWalker object does not represent any physical SQL Server object.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Examples

Scripting

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace