SQL Server 2005 Sync
nsomaraj
Posts: 2
Hi all..
I wand to SYNC SQL Server 2005 with SQL Server Compact Edition 3.5 using ASP.NET 2005 can any one tell is there any provision if yes give me the sample source code. Thanks
I wand to SYNC SQL Server 2005 with SQL Server Compact Edition 3.5 using ASP.NET 2005 can any one tell is there any provision if yes give me the sample source code. Thanks
Comments
SQL Comparison SDK only supports MS SQL Server at the moment, so it is not possible to use this to synchronize schema or data between SQL Server and SQL CE.
The API that is designed to do this sort of job is SQL Server Integration Services. Please see http://msdn.microsoft.com/en-us/library/ms141209.aspx .
Hope this helps.