MDB or SDF?? Access or SQL Server Compact Edition??

9 Feb 2007 9:40 PM

Paul Aspinall

Hi
I'm looking to find a debate / discussion on the merits of coding a .NET
application with either MDB or SDF files?? (ie. Access versus SQL Server
Compact Edition)

I guess the official line would be that SDF files should be used; but what
advantages does each have over the other??

Is there a MS paper discussing this?

Thanks

12 Feb 2007 9:13 PM

Cowboy (Gregory A. Beamer)

Have not seen this, but I would probably choose SQL. Not so much for the
anywhere engine, but the ability to more quickly upsize, if the need arose.

I would also aim for Express over Everywhere, if I had the option. While the
SQL Everywhere files are available for all windows OSs (from Mobile on up),
making them more flexible, I prefer having a server infrastructure of some
sort. Your mileage may vary. :-)

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

********************************************
Think outside the box!
********************************************

Show quote

"Paul Aspinall" <p***@aspy.co.uk> wrote in message
news:VS5zh.267794$Kh7.168958@fe2.news.blueyonder.co.uk...
> Hi
> I'm looking to find a debate / discussion on the merits of coding a .NET
> application with either MDB or SDF files?? (ie. Access versus SQL Server
> Compact Edition)
>
> I guess the official line would be that SDF files should be used; but what
> advantages does each have over the other??
>
> Is there a MS paper discussing this?
>
> Thanks
>