Getting client application data to enterprise database server

Question

I'm looking to use sql server compact edition for an application where users will not always be connected to the internet. Once the users regain an internet connection, I want them to be able to send the data to the enterprise sql server.

I started thinking about this and I don't want to have to loop through a recordset to submit each record one-by-one.

Normally, I would just do something like the following:

insert into table2
select * from table1

Can someone tell me how to proceed or easily send the data from the compact edition to the enterprise edition?

Answer 1

Try merge replication. The synchronization function is built in to the SQL Server and CE functions. You don't have to write code manually to sync rows.

Answer 2

The Sync Framework is designed to cover exactly these scenarios of mobile users connecting sporadically from smart devices, laptops and alike. See Introduction to Sync Framework Database Synchronization for a high level discussion. See Synchronizing Databases for a much more detailed discussion. Finally, see Database Sync - SQL Server and SQL Compact 2-Tier and Database Sync - SQL Server and SQL Compact N-Tier with WCF for working code samples.