SQL Server Express与MS Access [英] SQL Server Express vs MS Access

问题描述

最近与我一起工作的一位同事告诉我，SQL Express和MS Access本质上是同一件事.这似乎不是一个准确的说法.我知道您可以将Access转换为SQL DB，也许在幕后它们是相似的，但是我认为SQL DB引擎和用于运行访问的内容并不相同.不仅如此，我知道的SQL语句语法也不同.

A colleague I work with recently told me that SQL Express and MS Access were essentially the same thing; that does not seem to be an accurate statement. I know you can convert Access to a SQL DB and maybe under the covers they are similar, but I would assume that the SQL DB engine and what is used to run access are not the same. Not only that, but the SQL statement syntax, etc. I know are not the same.

我主要是试图理解，以便更了解版本.

I am mainly trying to understand so that I am more informed about the versions.

推荐答案

嗯，不，不一样.

首先，我需要弄清楚一些术语. MS Access是一种快速应用程序开发(RAD)工具，使您可以快速构建与关系数据绑定的表单和报表.它带有基于文件的数据库引擎(Jet/ACE).

First off, I need to clear up some terminology. MS Access is a Rapid Application Development (RAD) tool that allows you to quickly build forms and reports that are bound to relational data. It comes with a file-based database engine (Jet/ACE).

访问RAD工具可与许多不同的后端数据库(Jet，SQL Server，任何支持ODBC的数据库等)一起使用.我必须假设您的同事对Jet/ACE(即MS Access使用的数据库引擎)进行了专门评论.

Access the RAD tool can be used with many different backend databases (Jet, SQL Server, any db that supports ODBC, etc). I have to assume your colleague was specifically commenting on Jet/ACE, ie the database engine that MS Access uses.

我认为 Jet/ACE数据库引擎和MS SQL Server Express 是 Jet/ACE基于文件，而 SQL Server Express使用客户端/服务器模型.这意味着SQL Server Express需要运行的服务来提供对数据存储的访问.在某些情况下，这会使部署复杂化.

I think the single biggest difference between the Jet/ACE database engine and MS SQL Server Express is that Jet/ACE is file-based and SQL Server Express uses a client/server model. This means that SQL Server Express requires a running service to provide access to the datastore. This can complicate deployment in some scenarios.

SQL Server Express实际上只是SQL Server的精简版本:最大数据库大小为4GB(2008R2中为10GB)，仅使用单个物理CPU，等等.施加这些限制是为了防止大型组织自由使用可用的Express Edition代替了完整的SQL Server安装.结果是SQL Server Express提供了到SQL Server的真正无缝升级路径. (通常来说)它是一个比Jet/ACE更健壮且功能齐全的数据库管理系统.

SQL Server Express is really just a throttled-back version of SQL Server: max database size of 4GB (10GB in 2008R2), only uses a single physical CPU, etc. These limitations are imposed to prevent large organizations from using the freely available Express edition in place of a full-blown SQL Server install. The upshot to this is that SQL Server Express offers a truly seamless upgrade path to SQL Server. It is also (generally speaking) a more robust and fully featured database management system then Jet/ACE.

相似之处

• 关系数据库管理系统
• 由微软撰写

差异

• MS Access
  • 基于文件
  • 免费的可分发运行时(2007或更高版本)
  • RAD工具(表单/报表设计器)
  • 使用Jet SQL
  • 最大文件大小2GB
  • MS Access
    • File based
    • free distributable runtime (2007 or later)
    • RAD tools (form/report designer)
    • uses Jet SQL
    • max file size 2GB
    • 客户端/服务器模型
    • 免费
    • 没有RAD工具
    • 使用Transact-SQL
    • 最大数据库大小为4GB(对于SSE R2为10GB)，最大为一个物理CPU

    这篇关于SQL Server Express与MS Access的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！