Which DBMS should I use? RRS feed

  • Question

  • I'm a C# beginner and I've always used Access as a DBMS when programming with VB, but now I'd like to start using something else.

    Which free DBMS should I pick, that is also easy to use for a beginner?

    Thanks :)

    Sunday, January 2, 2011 8:11 PM


All replies

  • Microsoft SQL Sever Express is good choose, I think :) .
    在現實生活中,你和誰在一起的確很重要,甚至能改變你的成長軌跡,決定你的人生成敗。 和什麼樣的人在一起,就會有什麼樣的人生。 和勤奮的人在一起,你不會懶惰; 和積極的人在一起,你不會消沈; 與智者同行,你會不同凡響; 與高人為伍,你能登上巔峰。
    Sunday, January 2, 2011 8:24 PM
  • Thanks a lot :)

    I just installed it, but I feel like an idiot now because I don't find how to open it or create a database :(

    All I have in my start menu is "Import and export data", "SQL Server Configuration Manager", "SQL Server Error and Usage Reporting", and "SQL Server Installation Center".

    None of those provides a way for me to create a database, add tables and info to it...

    Am I being too dumb or is my installation corrupt in some way?

    Monday, January 3, 2011 12:00 AM
  • You need MSSE.


    Make sure you use the correct version for your version of SQL. 

    Mark the best replies as answers. "Fooling computers since 1971."


    Monday, January 3, 2011 12:26 AM
  • Personally, I like to use something like System.Data.SQLite .  It's free. It's a single dll when you distribute your app.  It does have vs integration and support for the Entity Framework if you want it...  I personally, have my own framework that I use - but, it was developed before ef :) 

    I personally, use SQLite Administrator to create and design the databases.

    Tom Shelton
    Monday, January 3, 2011 12:43 AM
  • Hello ex-lawyer!  In the summer of 2009 (a very short time ago) I went through exactly what you are going through now.  Jumping from Access to SQL Server is not necessarily easy, but the rewards are worth the efforts.  Check this out:


    You have to determine if you have a 64-bit machine or a 32-bit machine, then choose the appropriate file, download it, and install it.

    You may find that this is helpful too:


    Post back if you have specific questions.


    Thursday, January 6, 2011 2:24 AM