Which Database type to use?

  • Thread starter Thread starter Devlei
  • Start date Start date
D

Devlei

A have a simple one table database that I want users to access, use and
update from desktop and/or mobile device. Which database type is best
suited for the job? SQL, MS-Jet/Access, or simply XML?
 
The criteria for selection usually is (very briefly) :

1. SQL Server : Use this when you need a robust database solution, with high
performance, that can easily manage very large tables.

2. MS Access : Use this when you need a developer friendly and performant
database solution, that will not contain very large tables.

3. XML : Use this when interoperability between different platforms is your
main concern, and it's possible that above programs installed.

Regards,

Cerebrus.
 
One table database sounds a lot like a flat file to me. Without knowing the
data, how it will be used,
and how much, I would lean towards XML. I have used XML for solutions along
this line before
with great results.
 
Thanks for the response Ken!!

Can the desktop user open and update the SQLCE file directly, assuming
its location is in one of the sync folders?

Dave
 
Thanks "Cerebrus" and "Nobody" for your responses!!

Am I correct in concluding that in order to access the same file from
both desktop and device (assuming it in a sync folder), the best option
is to go XML?

Dave
 
Back
Top