Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Should I use SQL Express or Compact???

Author  Topic 

Trushar
Starting Member

2 Posts

Posted - 2007-02-11 : 11:25:19
Hi,

I have an application where I need a desktop Application to manage the data and I have PDA application which talks to RFID and gathers the data. I am a bit confused if i can have only one database which can work both on PDA and Desktop. Can you please help me decide if i should use compact or express for this purpose. Also I might have to use both compact and Express but is there a way to have common database for both where they can be replication and easily synchronised.

Help is much appreciated.

Regards
Trushar

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-11 : 11:48:04
I think the newest edition of SQL Server for PDA, cellphones and other handheld products, is named SQL Everywhere.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Trushar
Starting Member

2 Posts

Posted - 2007-02-11 : 12:23:29
Hi Peter,

Thanks for your reply. On googling i found this

'SQL Server Compact was previously named SQL Server 2005 Everywhere Edition during the product development phase'

Are you actually talking about this SQL Everywhere or is this something different.

Regards
Trushar
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-02-11 : 12:26:35
sql express runs only on a desktop

sql compact edition runs on desktops and PDAs.

Microsoft has a whitepaper regarding choosing between compact/express. That is probably your best place to start http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx



-ec
Go to Top of Page
   

- Advertisement -