DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > dBASE vs. Microsoft Access vs. Microsoft SQL Server

System Properties Comparison dBASE vs. Microsoft Access vs. Microsoft SQL Server

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NamedBASE  Xexclude from comparisonMicrosoft Access  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparison
DescriptiondBase was one of the first databases with a development environment on PC's. Its latest version dBase V is still sold as dBase classic, which needs a DOS Emulation. The up-to-date product is dBase plus.Microsoft Access combines a backend RDBMS (JET / ACE Engine) with a GUI frontend for data manipulation and queries. infoThe Access frontend is often used for accessing other datasources (DBMS, Excel, etc.)Microsofts flagship relational DBMS
Primary database modelRelational DBMSRelational DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score15.03
Rank#41  Overall
#26  Relational DBMS
Score132.06
Rank#10  Overall
#7  Relational DBMS
Score922.01
Rank#3  Overall
#3  Relational DBMS
Websitewww.dbase.comwww.microsoft.com/­en-us/­microsoft-365/­accesswww.microsoft.com/­en-us/­sql-server
Technical documentationwww.dbase.com/­support/­knowledgebasedeveloper.microsoft.com/­en-us/­accessdocs.microsoft.com/­en-US/­sql/­sql-server
DeveloperAsthon TateMicrosoftMicrosoft
Initial release197919921989
Current releasedBASE 2019, 20191902 (16.0.11328.20222), March 2019SQL Server 2022, November 2022
License infoCommercial or Open Sourcecommercialcommercial infoBundled with Microsoft Officecommercial inforestricted free version is available
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C++
Server operating systemsDOS infodBase Classic
Windows infodBase Pro
Windows infoNot a real database server, but making use of DLLsLinux
Windows
Data schemeyesyesyes
Typing infopredefined data types such as float or dateyesyesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yes
Secondary indexesyesyesyes
SQL infoSupport of SQLnoyes infobut not compliant to any SQL standardyes
APIs and other access methodsnone infoThe IDE can access other DBMS or ODBC-sources.ADO.NET
DAO
ODBC
OLE DB
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Supported programming languagesdBase proprietary IDEC
C#
C++
Delphi
Java (JDBC-ODBC)
VBA
Visual Basic.NET
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Server-side scripts infoStored proceduresno infoThe IDE can access stored procedures in other database systems.yes infosince Access 2010 using the ACE-engineTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Java
Triggersnoyes infosince Access 2010 using the ACE-engineyes
Partitioning methods infoMethods for storing different data on different nodesnonenonetables can be distributed across several files (horizontal partitioning); sharding through federation
Replication methods infoMethods for redundantly storing data on multiple nodesnonenoneyes, but depending on the SQL-Server Edition
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys infoReferential integrityyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infonot for dBase internal data, but IDE does support transactions when accessing external DBMSACID infobut no files for transaction loggingACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyes infobut no files for transaction loggingyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes
User concepts infoAccess controlAccess rights for users and rolesno infoa simple user-level security was built in till version Access 2003fine grained access rights according to SQL-standard

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services
3rd partiesSQL Complete: An advanced IntelliSense-style code completion add-in for SSMS and Visual Studio. Write, beautify, refactor your SQL code and give your productivity a dramatic boost.
» more

SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more

Navicat for SQL Server gives you a fully graphical approach to database management and development.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
dBASEMicrosoft AccessMicrosoft SQL Server
DB-Engines blog posts

DB-Engines Ranking coverage expanded to 169 database management systems
3 June 2013, Paul Andlinger

show all

MS Access drops in DB-Engines Ranking
2 May 2013, Paul Andlinger

Microsoft SQL Server regained rank 2 in the DB-Engines popularity ranking
3 December 2012, Matthias Gelbmann

New DB-Engines Ranking shows the popularity of database management systems
3 October 2012, Matthias Gelbmann, Paul Andlinger

show all

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

Recent citations in the news

Microsoft brings back dBASE file support (.dbf) in Access for Office ...
7 September 2016, MSPoweruser

Health Law Disruption: Cybersecurity and Emerging Data Risks, a Legal Docuseries by the American Health Law Association & dBase Media Premieres July 14, 2022
14 July 2022, Yahoo Finance

We Found the OG Tech Influencer
11 October 2022, PCMag

Retro Database dBASE Making a Comeback?
20 March 2013, Visual Studio Magazine

WFP DBase (Logistics Data, Budgets and Systems Execution ...
23 December 2019, ReliefWeb

provided by Google News

Using "global" variables in MS Access
4 December 2018, Experts Exchange

An Easy Guide on How to Use Microsoft Access Business Productivity Tool
15 March 2023, Simplilearn

Microsoft Access Tutorial: MS Access with Example [Easy Notes]
4 March 2023, Guru99

Microsoft Access: Is it still relevant in 2023? - Explore Alternatives
9 January 2023, comparitech.com

10 Best MS Access Training, Courses & Classes Online 2023
2 March 2023, codespaces.com

provided by Google News

SQL Server Monitoring Tools Market Research Report 2023-2033 Market Future Scope – Los Alamos Monitor
22 March 2023, Los Alamos Monitor

SQL Server 2022: Here’s what you need to know
29 July 2022, TechRepublic

What is Microsoft SQL Server? A definition from WhatIs.com
28 February 2022, TechTarget

implement the table structures in the database on SQL Server – PAPER ACER
26 March 2023, Bass Tone

SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS)
3 March 2023, Microsoft

provided by Google News

Job opportunities

Data Processor
Marie Leising & Associates, Michigan

Full Stack Developer (React JS & Python)
American Recruiting & Consulting Group, Remote

Variable Data Processor
Taylor Corporation, Grove City, OH

Conversational AI Developer
Stellar IT Solutions, Winter Garden, FL

Postal Analyst
Quad, West Allis, WI

MS Access Developer
First Merchants Bank, Daleville, IN

MS Access Developer
NCIS, Concord, NC

Data Analyst
Phoenix Loss Control, Remote

Receptionist
West Bradford Township, Downingtown, PA

MS Access Developer
American Tradeshow Services, Mandeville, LA

SQL Server Database Admin
Mindcracker, Remote

Senior SQL Server Developer
Info Origin Inc., Remote

SQL Server Architect
Five Star Logistics, Remote

SQL BI Developer
Agiles Enterprise, Remote

SQL Server DBA
Covestic, Remote

jobs by Indeed



Share this page

Featured Products

Cassandra Forward online event

Want to level up your Cassandra game?
If you missed the event or would like to re-watch a session, replays are available now. Watch now!

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Redis logo

The world’s most loved real‑time data platform.
Try free

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here