SqlCeReplication Constructor (String, String, String, String, String, String, String, String)

Initializes a new instance of the SqlCeReplication object and sets the required properties for connecting to a publication.

Namespace:  System.Data.SqlServerCe
Assembly:  System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)

Syntax

'Declaration
Public Sub New ( _
    internetUrl As String, _
    internetLogin As String, _
    internetPassword As String, _
    publisher As String, _
    publisherDatabase As String, _
    publication As String, _
    subscriber As String, _
    subscriberConnectionString As String _
)
'Usage
Dim internetUrl As String
Dim internetLogin As String
Dim internetPassword As String
Dim publisher As String
Dim publisherDatabase As String
Dim publication As String
Dim subscriber As String
Dim subscriberConnectionString As String

Dim instance As New SqlCeReplication(internetUrl, _
    internetLogin, internetPassword, _
    publisher, publisherDatabase, publication, _
    subscriber, subscriberConnectionString)

public SqlCeReplication(
    string internetUrl,
    string internetLogin,
    string internetPassword,
    string publisher,
    string publisherDatabase,
    string publication,
    string subscriber,
    string subscriberConnectionString
)

public:
SqlCeReplication(
    String^ internetUrl, 
    String^ internetLogin, 
    String^ internetPassword, 
    String^ publisher, 
    String^ publisherDatabase, 
    String^ publication, 
    String^ subscriber, 
    String^ subscriberConnectionString
)

new : 
        internetUrl:string * 
        internetLogin:string * 
        internetPassword:string * 
        publisher:string * 
        publisherDatabase:string * 
        publication:string * 
        subscriber:string * 
        subscriberConnectionString:string -> SqlCeReplication

public function SqlCeReplication(
    internetUrl : String, 
    internetLogin : String, 
    internetPassword : String, 
    publisher : String, 
    publisherDatabase : String, 
    publication : String, 
    subscriber : String, 
    subscriberConnectionString : String
)

Parameters

• internetUrl
  Type: System. . :: . .String
  The URL used to connect to the Server Agent.

• internetLogin
  Type: System. . :: . .String
  The login name used when connecting to the Server Agent.

• internetPassword
  Type: System. . :: . .String
  The password used when connecting to the Server Agent.

• publisher
  Type: System. . :: . .String
  The name of the Publisher.

• publisherDatabase
  Type: System. . :: . .String
  The name of the publication database.

• publication
  Type: System. . :: . .String
  The publication name that has been enabled for anonymous merge subscriptions.

• subscriber
  Type: System. . :: . .String
  The name of the Subscriber.

• subscriberConnectionString
  Type: System. . :: . .String
  The OLE DB connection string for the database on the -based device.

Examples

This example uses the AddSubscription and Synchronize methods to create a new subscription database.

Dim repl As SqlCeReplication = Nothing

Try
    ' Instantiate and configure SqlCeReplication object
    '
    'NOTE: when possible, prompt users to enter security 
    'credentials at runtime. If you store credentials in a file, 
    'you must secure the file to prevent unauthorized access.
    '
    repl = New SqlCeReplication()
    repl.InternetUrl = "https://www.adventure-works.com/sqlce/sqlcesa35.dll"
    repl.InternetLogin = "MyInternetLogin"
    repl.InternetPassword = "<enterStrongPassword>"
    repl.Publisher = "MyPublisher"
    repl.PublisherDatabase = "MyPublisherDatabase"
    repl.PublisherLogin = "MyPublisherLogin"
    repl.PublisherPassword = "<enterStrongPassword>"
    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

SqlCeReplication repl = null;

try
{
    // Instantiate and configure SqlCeReplication object
    //
    //NOTE: when possible, prompt users to enter security 
    //credentials at runtime. If you store credentials in a file, 
    //you must secure the file to prevent unauthorized access.
    //
    repl = new SqlCeReplication();
    repl.InternetUrl = "https://www.adventure-works.com/sqlce/sqlcesa35.dll";
    repl.InternetLogin = "MyInternetLogin";
    repl.InternetPassword = "<enterStrongPassword>";
    repl.Publisher = "MyPublisher";
    repl.PublisherDatabase = "MyPublisherDatabase";
    repl.PublisherLogin = "MyPublisherLogin";
    repl.PublisherPassword = "<enterStrongPassword>";
    repl.Publication = "MyPublication";
    repl.Subscriber = "MySubscriber";
    repl.SubscriberConnectionString = "Data Source=MyDatabase.sdf";

    // Create a local SQL Mobile Database subscription
    //
    repl.AddSubscription(AddOption.CreateDatabase);

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

See Also

Reference

SqlCeReplication Class

SqlCeReplication Members

SqlCeReplication Overload

System.Data.SqlServerCe Namespace