Last post Nov 07, 2012 08:07 PM by Decker Dong - MSFT
Nov 06, 2012 03:44 PM|mlaferriere|LINK
Hi Folks - I'm using VS Express 2010. I have a .mdb file that I would like to use with my ASP site. Data traffic would be moderate, read-only. Is a .mdb file an acceptable choice? Or, should I go .sdf? If .sdf is a better solution, how do I export/import
the data? Thanks.
Nov 06, 2012 04:35 PM|Mikesdotnetting|LINK
Data traffic would be moderate, read-only. Is a .mdb file an acceptable choice?
Yes. Make use of caching as much as you can too.
Or, should I go .sdf?
My preference would be sdf as it runs in process so should theoretically provide better performance. And it supports a wider range of T-SQL than JET. I'm not sure if there are any tools that will aid migration from Access to Sql Server CE, The only SQL Server
CE managment tool I'm aware of is this one: http://sqlcetoolbox.codeplex.com/
Otherwise you can do it though code.
Nov 07, 2012 08:07 PM|Decker Dong - MSFT|LINK
I have a .mdb file that I would like to use with my ASP site.
This is an asp.net site instead of pure asp one, so if you have futher information of asp, I suggest you asking questions here for futher help.
Here we talk about IIS and Classic ASP on official Microsoft's forum.