SqlCeReplication.ReinitializeSubscription Method

Marks a subscription for reinitialization. After calling this method, an application must call the Synchronize method to download the latest snapshot of the publication to the device.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Syntax

'Declaration
Public Sub ReinitializeSubscription ( _
    uploadBeforeReinitialize As Boolean _
)
'Usage
Dim instance As SqlCeReplication
Dim uploadBeforeReinitialize As Boolean

instance.ReinitializeSubscription(uploadBeforeReinitialize)

public void ReinitializeSubscription (
    bool uploadBeforeReinitialize
)

public:
void ReinitializeSubscription (
    bool uploadBeforeReinitialize
)

public void ReinitializeSubscription (
    boolean uploadBeforeReinitialize
)

public function ReinitializeSubscription (
    uploadBeforeReinitialize : boolean
)

Not applicable.

Parameters

• uploadBeforeReinitialize
  If True, the changes in the subscription database are uploaded to the Publisher before the snapshot is applied at the Subscriber. The default is False.

Remarks

A flag is marked in the SQL Server Compact Edition subscription system table to signify that during the next synchronization, the subscription should be reinitialized. After calling the ReinitializeSubscription method, the application must call the Synchronize method to delete the existing replica and download a new replica of the publication to the Windows Mobile-based device.

Example

Dim repl As SqlCeReplication = Nothing

Try
    ' Create SqlCeReplication instance
    '
    repl = New SqlCeReplication()
    repl.InternetUrl = "https://www.adventure-works.com/sqlmobile/sqlcesa30.dll"
    repl.InternetLogin = "MyInternetLogin"
    repl.InternetPassword = "<password>"
    repl.Publisher = "MyPublisher"
    repl.PublisherDatabase = "MyPublisherDatabase"
    repl.PublisherLogin = "MyPublisherLogin"
    repl.PublisherPassword = "<password>"
    repl.Publication = "MyPublication"
    repl.Subscriber = "MySubscriber"
    repl.SubscriberConnectionString = "Data Source=MyDatabase.sdf"

    ' Mark the subscription for reinitialization with Upload first
    '
    repl.ReinitializeSubscription(True)

    ' Synchronize to the SQL Server to populate the Subscription 
    '
    repl.Synchronize()
Catch
    ' Handle errors here
Finally
    ' Dispose the repl object
    '
    repl.Dispose()
End Try

SqlCeReplication repl = null;

try
{
    // Create SqlCeReplication instance
    //
    repl = new SqlCeReplication();
    repl.InternetUrl = "https://www.adventure-works.com/sqlmobile/sqlcesa30.dll";
    repl.InternetLogin = "MyInternetLogin";
    repl.InternetPassword = "<password>";
    repl.Publisher = "MyPublisher";
    repl.PublisherDatabase = "MyPublisherDatabase";
    repl.PublisherLogin = "MyPublisherLogin";
    repl.PublisherPassword = "<password>";
    repl.Publication = "MyPublication";
    repl.Subscriber = "MySubscriber";
    repl.SubscriberConnectionString = "Data Source=MyDatabase.sdf";

    // Mark the subscription for reinitialization with Upload first
    //
    repl.ReinitializeSubscription(true);

    // Synchronize to the SQL Server to populate the Subscription 
    //
    repl.Synchronize();
}
catch (SqlCeException)
{
    // Handle errors here
}
finally
{
    // Dispose the repl object
    //
    repl.Dispose();
}

Platforms

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

Version Information

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0, 1.0

See Also

Reference

SqlCeReplication Class
SqlCeReplication Members
System.Data.SqlServerCe Namespace