Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server CE

Status
Not open for further replies.

ianbara

Programmer
Jul 12, 2002
4
GB
Can anyone give me any clues on creating a SQL Server CE database?? Ive read the book online and im stumped!

I want to be able to synchronize a SQL Server CE Database on a PDA.

Cheers
Ian
 
Never done it, but does your PDA use Windows CE as it's operating system?

You might also want to let us know what problems you are having.

-SQLBill
 
Yes the PDA OS is Windows CE.
I am creating forms for the PDA using Visual CE. Ive downloaded the tables i need to the PDA and they run fine. Apart from the fact that i cant get them to synchronize with the server.

I read in the Visual CE help file that : You cannot use Visual CE synchronization software to synchronize .sdf files with a database on the desktop PC. You must use Microsoft's Database Synchronization software instead.

Wanted to know if when I download the SQL to the PDA its converted to a SQL CE db. I think it is but im not sure.

I dont have a clue how to synchronize the tables though. Read something about Remote Data Access (RDA) and Merge Replication.

Don't really know wot to do next.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top