Save/convert sql server ce database to sql server 2008 database

How can you save/converta SQL CE 3.5 sdf file to a SQL Server 2008 R2 Express file?

We want to be able to link to the SQL Server 2008 database tables via Microsoft Access front-end linked tables.

SQL Server CE (sdf) <--> SQL Server 2008 <--linked tables--> MS Access front-end
mph23Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mph23Author Commented:
Would you recommend this ExportSQLCE as a good tool so that we can write command line scripts?

The data on the device (SQL CE) and the desktop (SQL Server 2008 Express) will be changing daily so we'll probably have to write a synch program.

I see that codeplex also has a SQL Compact Command Line Tool.

Have you used either of these products?
0
 
Mikal613Commented:
No, I have used the other way. SQL 2k8 -> CE. I use old fashioned Web services and WCF to sync data from my WM device to my SQL server,
0
 
mph23Author Commented:
Ok thanks. I also found something by Primeworks so will try both and see.
Thanks
0
 
mph23Author Commented:
I am able to use primeworks Data port Wizard but will try your suggestion to see if I can automate it.

thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.