This is a very simple variation on my last blog post: instead of copying the table to the same database, you can now copy it to another database (although with the same table name, but you can easily change that). The table data is exported in the Export method of the SqlCeTableTool class using a SqlCeDataReader for reading and a SqlCeResultSet for writing. Simple stuff, really...
Sample code: CopyTableSample2.zip
Hi João. I blogged about your 2 samples here:
ReplyDeletehttp://erikej.blogspot.com/2010/06/sql-compact-table-copyexport-samples.html