Local Database

MS SQL Server

SQL Server is a relational database management system (RDBMS) from Microsoft.   It supports ANSI SQL, which is the standard Structured Query Language.   This is not the same as the T-SQL (Transact-SQL) designed and developed to compete with MySQL and Oracle databases.  

How to Install SQL Server for Windows (FREE)

[this is an older version of SQL Server]   Microsoft SQL Server 2016 Express LocalDB is a feature of SQL Server Express targeted to developers.   The LocalDB installation is a minimal set of files necessary to start the SQL Server Database Engine.   When connected, the SQL Server is automatically created and started.   Follow this link for more information about SQL Server 2016 LocalDB.   To install MS SQL 2016 Express LocalDB, download SQL Server 2016 Express with Advanced Services (file 'SQLServer2016-SSEI-Expr.exe') and chose the 'Download Media' installation type option, followed by the 'LocalDB' download option.   The best development environment is achieved when you also install SQL Sever Management Studio (SSMS) (file 'SSMS-Setup-ENU.exe').  

Example of a VBScript connection string:

  Set oDBConn = CreateObject("ADODB.Connection")
  oDBConn.ConnectionString = "Driver={SQL Server Native Client 11.0};Server=(localdb)\MSSQLLocalDB;Database=YourDatabaseName;Trusted_Connection=yes;MultipleActiveResultSets=true"

 

Database Front End Tools

Several tools exist that allow you to create, edit, view, and query databases.  

DBeaver is a free and open source database front end.