SqlProvider Class

The provider for access to SQL Server databases.

For a list of all members of this type, see SqlProvider members.

Object Model

Inheritance Hierarchy

System.Object
   RedGate.SQLDataCompare.Engine.SqlProvider

Syntax

[Visual Basic]
Public Class SqlProvider 
   Implements ICancellable 

[C#]
public class SqlProvider : ICancellable 

[C++]
public __gc class SqlProvider : public ICancellable 

[C++/CLI]
public ref class SqlProvider : public ICancellable 

Remarks

Use GetMigrationSQL to get an ExecutionBlock containing the SQL script to migrate data between two databases. It also provides helper methods used internally by SQL Data Compare.

Example

See ComparisonSessionfor code samples on comparing data See GetMigrationSQLfor code samples on synchronizing data.

Requirements

Namespace: RedGate.SQLDataCompare.Engine

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

Assembly: RedGate.SQLDataCompare.Engine (in RedGate.SQLDataCompare.Engine.dll)

See Also

SqlProvider Members  | RedGate.SQLDataCompare.Engine Namespace

© 2003 - 2006 Red Gate Software Ltd. All Rights Reserved.