SQL Server 2005 Sync

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

SQL Server 2005 Sync

Postby nsomaraj » Tue Jun 22, 2010 6:05 am

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
nsomaraj
 
Posts: 1
Joined: Tue Jun 22, 2010 5:42 am

Postby Brian Donahue » Wed Jun 23, 2010 9:41 am

Hi,

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests