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?
SQL Server > SQL Server Replication
Comments
Post a Comment