none
SQL Database - Where to start

    Question

  • For my projects requiring a local database I've been using MS Access.  This works just fine for now, but I wanted to learn how to create and use an SQL database but not sure where to begin.  I've done some reading elsewhere but can't really find a good place for newbies... anyone able to point me in the right direction?

    Thank you!

    Tuesday, September 18, 2012 1:12 AM

Answers

  • With a SQL Database can be meant many things. Some call every database which uses SQL transact code an SQL Database (so MS Access too). Others mean by that only a Microsoft SQL Server database (There is also Microsoft SQL Server Compact Edition which is not even a server).

    If it is about Microsoft SQL Server, then download SQL Server Express 

     http://msdn.microsoft.com/en-us/evalcenter/hh230763.aspx

     And get started


    Success
    Cor

    • Marked as answer by MBuchok Tuesday, September 18, 2012 10:44 AM
    Tuesday, September 18, 2012 5:21 AM

All replies

  • With a SQL Database can be meant many things. Some call every database which uses SQL transact code an SQL Database (so MS Access too). Others mean by that only a Microsoft SQL Server database (There is also Microsoft SQL Server Compact Edition which is not even a server).

    If it is about Microsoft SQL Server, then download SQL Server Express 

     http://msdn.microsoft.com/en-us/evalcenter/hh230763.aspx

     And get started


    Success
    Cor

    • Marked as answer by MBuchok Tuesday, September 18, 2012 10:44 AM
    Tuesday, September 18, 2012 5:21 AM
  • At the moment, I'm just looking at creating a local database in SQL since I don't have a server.  I downloaded MySQL which seems relatively easy to use.  I don't have really any knowledge of SQL so it's probably going to be a bumpy ride for me for the next week or two until I figure this out.

    Thanks for that link though.  I'm going to explore both MySQL and SQL Server Express.  After I familiarize myself I may look into a server database.

    Tuesday, September 18, 2012 10:44 AM
  • MySQL is not microsoft, while MySQL is a substitute for SQL Server Express, so not local.

    For Local use Microsoft has SQL Server CE

    http://blogs.msdn.com/b/sqlservercompact/archive/2011/01/12/microsoft-sql-server-compact-4-0-is-available-for-download.aspx


    Success
    Cor

    Tuesday, September 18, 2012 11:25 AM