• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1756
  • Last Modified:

Export From MS SQL Server to SQL CE .sdf File?

Is is possible to export data from sql directly to a sql ce .sdf file?  I am trying to distribute data to 20 or so pocet pc's which will not be on the network.  They will work remotely and access data via a dialup, internet or PC anywhere.  I am concerned that RDA will be too difficult since all the pocet pc's will be attached to one desktop pc.  
1 Solution
Unfortunately no.  The newest version of SQLCe that will interact with SQL2005 will allow some more flexible options, but until then, you don't have too many options.
gerrystratAuthor Commented:
Ok, thanks.  I figure I'll just send csv files back and forth.  I could import them with a filestream object and fill up a sql ce database to work with.  This will happen when the app loads.  I hope it won't be too slow.  If you have any comments, I'd appreciate them.


Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now