sql server replication: Hi,

I wonder where can I set the UPLOAD ONLY parameter in the following codes in
CE (VB.Net CF), or where I should change the settings in the SQL server?

Try
Dim repl As New SqlCeReplication()
repl.InternetUrl = "http://developer/snapshot/sqlcesa30.dll"

repl.Publisher = "DEVELOPER"
repl.PublisherDatabase = "MyDB"
repl.PublisherSecurityMode = SecurityType.NTAuthentication
repl.Publication = "MyPub"
repl.Subscriber = "MySub"
repl.InternetLogin = "administrator"
repl.InternetPassword = "somewhere"
repl.SubscriberConnectionString = _
"Data Source='" + filename + "';Password='';" _
& "Max Database Size='128';Default Lock Escalation ='100';"

'repl.AddSubscription(AddOption.CreateDatabase)

repl.Synchronize()
Return True
Catch ex As Exception
MsgBox(Err.Description)
Return False
End Try


Thanks,

Luke

Hi

There is no way to do this in code. In publication propertis there is
also no option for this.
You can do this by replication filter. Just add to Filter table whith
where statment like '1=2' (it shuld always have false value).

Tomek

[quoted text, click to view]