SQL CE to SQL Server Transfer..

[rothj0hn]

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

[petevick]

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

[rothj0hn]

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

[petevick]

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

[rothj0hn]

Thanks Pete..

[szlamany]

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?