Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 08, 2012 12:07 AM by Decker Dong - MSFT
Nov 06, 2012 07:44 PM|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 08:35 PM|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 08, 2012 12:07 AM|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.