Work with SQLServer 2000 CE

[Dany]

Hi, I have to work with a SQLServer 2000 database. How I migrate the
database with all data to the iPAQ? I have installed sqlserver CE and i can
create a database with SQLCE Query but i don't know the way to use my
sqlserver database.

Help please!!

 

[Ginny Caughey [MVP]]

Dany,

Most people use merge replication to move data back and forth between SQL
Server and SQL Server CE. RDA pull is another option.

 

[Rick Winscot]

Dany,

Ginny's suggestion of Merge Replication would be ideal for having an exact
copy of the DB on the handheld and on the server. If you just want to have
the data from SQL Server on the handheld - I would suggest RDA (Remote Data
Access). If you are stuck - I'd be happy to point you at some articles or
send you some RDA code in .NET or eVB to get you up and running.

Rick Winscot
rickly@zyche dot com

 

[Frank Lombardo]

Rick,

I am developing a CE application that has to collect and store
relational data. I think SQL Server CE is the best choice on the
device. I also want to provide a PC application for more advanced
data analysis of the data collected with the CE device. The problem
is, I don't want to require the end user to have SQL Server installed
on their machine. Is there some way to export the data from SQL
Server CE into something like an Access DB? I am open to any
suggestions you may have.

Thanks,
Frank

 

[Ginny Caughey [MVP]]

Frank,

You have several options, but I think the main thing is deciding what you
want the desktop app to use for a data source. If you don't want to require
SQL Server on each desktop, one option would be MSDE.

A completely different approach would be to use CSV files. There is a CSV
library on www.opennetcf.org that provides a data adapter for CSV files to
work with datasets. Depending on the volume of data you expect, this
approach might work for you on the desktop too.

XML is a third option, and it is very easy to use with datasets on either
the device or the desktop, but it is bulkier and slower to parse than CSV.

 

[Ryan Baumchen]

-----Original Message-----
Dany,

Ginny's suggestion of Merge Replication would be ideal for having an exact
copy of the DB on the handheld and on the server. If you just want to have
the data from SQL Server on the handheld - I would suggest RDA (Remote Data
Access). If you are stuck - I'd be happy to point you at some articles or
send you some RDA code in .NET or eVB to get you up and running.

Rick Winscot
rickly@zyche dot com


sqlserver CE and i
can


.
I have having the same problem I cant seem yo get IIS

configured correctly or something anyhelp on RDA Push and
Pull would be greatly appreciated

 

[Rick Winscot]

Frank,

Ginney's suggestion for MSDE may need some explaining... If I understand
your question correctly... you have a handheld application and need to get
the data to the desktop for more advanced analysis without using the full
SQL Server product? If this is the case - MSDE can work if you write your
own service for data synchronization. The SQL CE Agent stuff only works
with the full SQL Server 7/2000 product. If you decide to go with MSDE - I
have some code to make sure that MSDE is running properly when your app
starts.

As a second suggestion... you can use a pocket access db. Use RAPI to copy
the db's to the desktop (which converts them to an access db) and run a .NET
directory listener... as soon as the files are copied to the desktop they
can be imported into a central database of your choice. It all depends on
how fancy you want to get.

Let me know if any thing that I've suggested sound appealing - I'd be happy
to send you source or work with you on a solution.

Cheers,

Rick Winscot
rickly@zyche dot com