Request for DB selection
-
Hi all. I am designing a C# project which has so much to do with databases. Up to now , I didn't have much experience about multiuser apps. Which database (Access , SQLServer, NOT Oracle ....) should I use for a "multiuser & high-frequency accessed & middle mass" data record? Any proverb or url is welcome. (A comparison schema you know?) Utku KAYA
-
Hi all. I am designing a C# project which has so much to do with databases. Up to now , I didn't have much experience about multiuser apps. Which database (Access , SQLServer, NOT Oracle ....) should I use for a "multiuser & high-frequency accessed & middle mass" data record? Any proverb or url is welcome. (A comparison schema you know?) Utku KAYA
-
Access is not for multiuser usage, its a desktop database. You should use SQLServer .(Of course I didn't talk about price & licening) Mazy "Man is different from animals in that he speculates, a high risk activity." - Edward Hoagland
Access can be used for workgroups, but it isn't optimized for such and can be much slower since it is file-based.
Microsoft MVP, Visual C# My Articles
-
Hi all. I am designing a C# project which has so much to do with databases. Up to now , I didn't have much experience about multiuser apps. Which database (Access , SQLServer, NOT Oracle ....) should I use for a "multiuser & high-frequency accessed & middle mass" data record? Any proverb or url is welcome. (A comparison schema you know?) Utku KAYA
SQL Server has specialized support in the .NET Framework and has since 1.0. Oracle does not as well starting with 1.1 (there was a separate install before, but it wasn't officially supported). Price is definitely a concern with both. Like Mazdak said, though - Access is not optimized for multi-user environments. It's also file-based, and any file-based database solution has major cons. One nice thing about SQL Server, though, is that they have a freely downloadable and distributable desktop engine called MSDE. For all intents and purposes, it is SQL Server. It doesn't support near as many connections (only 10) but supports everything else from transations to backups. You can find more information about it at http://www.microsoft.com/sql/msde[^]. If you installed the defaults for VS.NET, you'll also have the setup on your machine already in the Setup\MSDE directory of your VS.NET installation root. Having applications like VS.NET, FoxPro (last I checked many years ago), Access, Office, and few others gives you redistributable rights to MSDE. Check it out. The really nice thing is that if you ever need to upgrade to the full SQL Server solution, just re-use the same MDF and LDF files from MSDE. Like I said, for all intents and purposes MSDE and SQL Server are the same.
Microsoft MVP, Visual C# My Articles