SQL CE to SQL Server Transfer..

Hi guys how do you transfer data from SQL CE to SQL Server and Vice Versa?

Depends on what you mean.

Replication for live systems for keeping data in sync.

I have a product (RemoteSQLCe) which I use for generating databases/data from SQL Server/Access.

There is a great free product from Erik Jensen for moving data from one base to another base here

Does it create an exact copy of database? What if i want to filter the content and pass only the data that i need?

RemoteSQLCe does what you want (but it isn't free) - Primeworks also have offerings (also not free)

You would have to look at the details of SQL Compact command line tool

Erik Jensen has a comprehensive list here

Thanks Pete..

We create VIEW in MS SQL SERVER that "respect" the simpler datatypes in SQL CE and we have a general routine that "reads" the schema of the views and makes those tables in the SQL CE database.

That's a really simple way to achieve at least one-way direction.

For write back to the MS SQL SERVER from the PPC we have a dirty flag we set in the SQL CE tables that allows us to run SERVER-SIDE SPROCS from the PPC for "the other direction".

Do you leave with a copy of SERVER-SIDE data that can be updated in 100% of all the ways possible on the PPC?