copying data from a SQL server-table to a SQLCE-table I want to copy some data from a MSSQL table to a SQLCE table in database.net.

I used the following query, connected to the MSSQL db:

update [SQLCE-table] ([column])
SET (column) FROM [MSSQL]


I keep getting several error messages like token in error = (].
What am I doing wrong?
After reading the comment, I would like to suggest that you can use SQL Server Compact bulk copy library


Check sqlcebulkcopy.codeplex.com
Or you can use ErikEJ’s blog post to migrate and the utility SQLCMD.
Or create Integration Services packages that write data to SQL Server Compact databases check link