SQL Server to SQL server CE

  • Thread starter Thread starter David Amador
  • Start date Start date
D

David Amador

I want to pass data of SQL Server to SQL server CE ... Is it possible and
which the process is?
 
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.
 
Back
Top