SqlCeReplication Class
.NET Framework 2.0
Initializes a new instance of the SqlCeReplication object. For more information about SQL Server replication, see the SQL Server 2005 Books Online. For more information about merge replication with SQL Server Mobile, see the SQL Server Mobile Books Online.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
The following example shows how to synchronize data between a SQL Server Mobile Subscriber and a SQL Server Publisher. A SqlCeReplication object is created, numerous properties of the SqlCeReplication object are set, and then the Synchronize method is called.
Dim repl As SqlCeReplication = Nothing Try ' Instantiate and configure SqlCeReplication object ' repl = New SqlCeReplication() repl.InternetUrl = "http://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" ' Create the local SQL Mobile Database subscription ' repl.AddSubscription(AddOption.CreateDatabase) ' Synchronize to the SQL Server to populate the Subscription ' repl.Synchronize() Catch ' Handle errors here ' Finally ' Dispose the repl object ' repl.Dispose() End Try
Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.
Community Additions
ADD
Show: