SQL CE and Getting Data from notebook

[info]

Hi There


I've some trouble on finding and good solution to get my Data from the
Notebook to my PDA.

I've some data in FoxPro DBF (DBase Like) on my Notebook. ( Upto 50.000
Datarows) What would be the best way to get them on the PDA?

I tried to write them to XML and send themn to the pda which schould
import the data. But the CF ist very very slow when a XML FIle is
bigger then 1 MB.

The Comserver could also transform the data into access, excel, CSV
etc.

I heard that it is possible to let AcitveSync synchronize access db''s
between NB and PDA. Does this synch work filebased or datarow based?

So I would only have to keep the 2 databases current and let AS the
Synch work done.

What about performance of an AccessDatabase when it has about 50.000
records?

Would it be a good think if i would only make the communication via
this access synch and then let der PDA import the files from the access
DB to the SQL CE Database?


Many questions. Hope that you can help me
Thank a lot for your help!

 

[João Paulo Figueira [eMVP]]

There are a number of ways to solve your problem. If you don't want to
convert the data format (DBF), you will have to use a third party tool such
as Sequiter's CodeBase on the PDA. If data conversion is an option, you can
convert to Access or to SQL Server. Native synchronization with Access means
you will get a "Pocket Access" database on the PDA that is not robust enough
for the volume of data you have. If you convert your data to SQL Server, you
can then use SQL CE 2.0 or SQL Mobile (3.0) on the device and natively
synchronize the data between the two. To use an "in-between" solution like
converting from Access to SQL CE, you will have to purchase a thrid-party
tool.

 

[info]

Hi there

I'd like to work without Access and without codebase but how could I
natevily transport the Data to the PDA ?
Is CSV an practicabel way ?

The other one would be an possibility to insert the data from the
Notebook to the PDA via RAP I etc.. In Normal cases there will only be
a small number of record that have to be synchronized but the first
import willl be a big thing . so would it be possible to fill the SQL
CE DB on the PC and then transfer the whole filled Database back to the
PDA ?

Are there other third party tools for automatic Datasynch or Remote SQL
CE Connectivity?

 

[Pete Vickers [MVP]]

Hi,
take a look at SqlLinkCE on our site - allows you to read ODBC databases on
your pc/server from your PPC

Thanks

Pete