Importing bulk Data to SQL CE (insert/update)

[Debu Das]

Hello,

I am developing Pocket PC Application with .NET Compact Framework and
SQL Server CE 2.0.

In the Application I need to update/insert large amount of data on a
daily basis(Master table contains 2000 records and child table
contains around 15000 records). In all I am having 8 tables. I am
having data in flat text files, I process these text files and insert
or update the record in database. This process takes more than an
hour. I want to minimise the processing time.

Is there any way to update the .SDF file on development computer?

I tried using evaluation version of SSCEDirect TM v.91 data loader for
SQL CE 2.0 for inserting records which is been read from a flat text
file. I am not been able to update existing records through this
product.
Does anybody know any other product that does the job of
insert/Update?

Also Merge Replication cannot be done as it required IIS & SQL server
to be installed on the seperate Machine.

Is there any other work around for it?

Any suggestion will be highly appreciated.

Thanks,

Debu

 

[João Paulo Figueira [eMVP]]

Hi,
I have developed a line of products that may help you on this: Data Port
Wizard, Data Port Command and Data Port Component. These products will
upload either SQL Server 2000 or Access databases to the SQL CE device over
ActiveSync. The products are very fast because they use low-level protocols
for accessing the databases and data is transferred in binary format.
Although these products will not export from flat files, you can import to
Access and export from there. You can read more / download here:
www.primeworks.pt

 

[Graham McKechnie]

Debu,

This process takes more than an
hour. I want to minimise the processing time.

Something doesn't sound right here. I'm processing in a similar way about
140,000 rows into about 20 tables and it takes about 50 mins. Could you show
some of the code you use to do this?

Graham