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.
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.
mlaferriere
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/
None
0 Points
8 Posts
Microsoft Access Database
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.
Michael
All-Star
194881 Points
28101 Posts
Moderator
Re: Microsoft Access Database
Nov 06, 2012 04:35 PM|Mikesdotnetting|LINK
Yes. Make use of caching as much as you can too.
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.
All-Star
94130 Points
18109 Posts
Re: Microsoft Access Database
Nov 07, 2012 08:07 PM|Decker Dong - MSFT|LINK
My addition,
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.
http://forums.iis.net/1044.aspx
Here we talk about IIS and Classic ASP on official Microsoft's forum.