I'd probably recommend using Replication to accomplish this but if for some
reason that's not an option, configure a SqlDataAdapter object to point to
big Sql and fill a datatable/dataset from it. Set the
AcceptChangesDuringFill property to false. Then, configure one pointing to
SqlCe and call its update method passing in the same exact datatable.
however this is a hack in most cases - use replication if you can.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
