Synchronization operation from server side


hi

i doing task synchronize data between sql server 2005 , sql mobile.

created publication in sql server 2005

created subscription in device thru coding. code below.

sqlcereplication repl = null;

try

{

repl = new sqlcereplication();

repl.interneturl = @"http://localhost/testfirst/sqlcesa30.dll";

repl.publisher = @"zcs6";

repl.publisherdatabase = @"testnow72743";

repl.publishersecuritymode = securitytype.dbauthentication;

repl.publisherlogin = @"sa";

repl.publisherpassword = @"test";

repl.publication = @"testfirst";

repl.subscriber = @"testnow7274310";

repl.subscriberconnectionstring = @"data source = '\testfirst.sdf';";

if (!file.exists(@"\testfirst.sdf"))

repl.addsubscription(addoption.createdatabase);

repl.synchronize();

}

catch (exception ex)

{

messagebox.show(ex.message);

}

finally

{

repl.dispose();

}

if run code device replication work successfully. calling synchronize device.

my question how can start synchronization server side. possible server side?

no, cannot initiate sync server side.


SQL Server  >  SQL Server Replication



Comments

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........