功能比較:Azure SQL Database 與 SQL ServerFeature comparison: Azure SQL Database versus SQL Server

Azure SQL Database 與 SQL Server 共用通用的程式碼基底。Azure SQL Database shares a common code base with SQL Server. Azure SQL Database 所支援的 SQL Server 功能取決於您所建立的 Azure SQL 資料庫類型。The features of SQL Server supported by Azure SQL Database depend on the type of Azure SQL database that you create. 使用 Azure SQL Database 時,您可以將資料庫建立為受控執行個體的一部分、作為單一資料庫,或為彈性集區的一部分。With Azure SQL Database, you can create a database as part of a managed instance, as a single database, or as part of an elastic pool.

Microsoft 會持續為 Azure SQL Database 新增功能。Microsoft continues to add features to Azure SQL Database. 請使用下列篩選來瀏覽 Azure 的「服務更新」網頁,以尋找最新更新:Visit the Service Updates webpage for Azure for the newest updates using these filters:

如果您需要更多有關差異的詳細資料, 您可以在單一資料庫和彈性集區的個別頁面中找到它們, 或受控執行個體If you need more details about the differences, you can find them in the separate pages for Single database and Elastic pools or Managed Instance.

SQL 功能SQL features

下表列出 SQL Server 的主要功能, 並提供有關此功能在受控執行個體或單一資料庫和彈性集區中是否部分或完全支援的資訊, 以及有關此功能的詳細資訊連結。The following table lists the major features of SQL Server and provides information about whether the feature is partially or fully supported in Managed Instance or Single Database and Elastic pools, with a link to more information about the feature.

SQL 功能SQL Feature 單一資料庫和彈性集區Single databases and elastic pools 受控實例Managed instances
一律加密Always Encrypted 是 - 請參閱憑證存放區金鑰保存庫Yes - see Cert store and Key vault 是 - 請參閱憑證存放區金鑰保存庫Yes - see Cert store and Key vault
Always On 可用性群組Always On Availability Groups 每個資料庫皆隨附高可用性High availability is included with every database. Azure SQL Database 的業務連續性概觀會討論災害復原Disaster recovery is discussed in Overview of business continuity with Azure SQL Database 每個資料庫都包含高可用性, 而且不能由使用者管理High availability is included with every database and cannot be managed by user. Azure SQL Database 的業務連續性概觀會討論災害復原Disaster recovery is discussed in Overview of business continuity with Azure SQL Database
連結資料庫Attach a database No No
應用程式角色Application roles Yes Yes
稽核Auditing Yes , 但有一些差異Yes, with some differences
自動備份Automatic backups 是的。Yes. 每隔7天、差異12小時和記錄備份每隔5-10 分鐘會執行一次完整備份。Full backups are taken every 7 days, differential 12 hours, and log backups every 5-10 min. 是的。Yes. 每隔7天、差異12小時和記錄備份每隔5-10 分鐘會執行一次完整備份。Full backups are taken every 7 days, differential 12 hours, and log backups every 5-10 min.
自動調整 (計劃強制) (機器翻譯)Automatic tuning (plan forcing) Yes Yes
自動調整 (索引) (機器翻譯)Automatic tuning (indexes) Yes No
備份命令BACKUP command 否,僅限系統起始的自動備份 - 請參閱自動備份No, only system-initiated automatic backups - see Automated backups 是, 使用者已起始僅限複本備份到 Azure Blob 儲存體 (使用者無法起始自動系統備份)-請參閱備份差異Yes, user initiated copy-only backups to Azure Blob Storage (automatic system backups cannot be initiated by user) - see Backup differences
內建函式Built-in functions 大部分 - 請參閱個別函式Most - see individual functions 是 - 請參閱預存程序、函式、觸發程序差異Yes - see Stored procedures, functions, triggers differences
BULK INSERT 語句BULK INSERT statement 是, 但只從 Azure Blob 儲存體作為來源。Yes, but just from Azure Blob storage as a source. 是, 但只從 Azure Blob 儲存體做為來源-請參閱差異Yes, but just from Azure Blob Storage as a source - see differences.
憑證和非對稱金鑰Certificates and asymmetric keys 是, 不需要存取和BACKUP CREATE作業的檔案系統。Yes, without access to file system for BACKUP and CREATE operations. 是, 不需要存取BACKUPCREATE作業的檔案系統-請參閱憑證差異Yes, without access to file system for BACKUP and CREATE operations - see certificate differences.
變更資料捕獲-CDCChange data capture - CDC No Yes
變更追蹤Change tracking Yes Yes
定序 - 資料庫Collation - database Yes Yes
定序 - 伺服器/執行個體Collation - server/instance 否, 一律會使用預設SQL_Latin1_General_CP1_CI_AS邏輯伺服器定序。No, default logical server collation SQL_Latin1_General_CP1_CI_AS is always used. 是, 可以在建立實例時設定, 而且之後無法更新。Yes, can be set when the instance is created and cannot be updated later.
資料行存放區索引Columnstore indexes 是 - 進階層、標準層 - S3 以上、一般用途層和業務關鍵層Yes - Premium tier, Standard tier - S3 and above, General Purpose tier, and Business Critical tiers Yes
Common language runtime-CLRCommon language runtime - CLR No 是, 但不能存取語句中CREATE ASSEMBLY的檔案系統-請參閱CLR 差異Yes, but without access to file system in CREATE ASSEMBLY statement - see CLR differences
自主資料庫Contained databases Yes Yes
自主使用者Contained users Yes Yes
控制流程語言關鍵字Control of flow language keywords Yes Yes
認證Credentials 是, 但只有資料庫範圍認證Yes, but only database scoped credentials. 是, 但只支援 Azure Key Vault SHARED ACCESS SIGNATURE和, 請參閱詳細資料Yes, but only Azure Key Vault and SHARED ACCESS SIGNATURE are supported see details
跨資料庫/三部分名稱查詢Cross-database/three-part name queries 否 - 請參閱彈性查詢No - see Elastic queries 是,再加上彈性查詢Yes, plus Elastic queries
跨資料庫交易Cross-database transactions No 是, 在實例內。Yes, within the instance. 請參閱跨實例查詢的連結伺服器差異See Linked server differences for cross-instance queries.
資料指標Cursors Yes Yes
資料壓縮Data compression Yes Yes
Database mail-DbMailDatabase mail - DbMail No Yes
資料庫鏡像Database mirroring No No
資料庫組態設定Database configuration settings Yes Yes
資料庫快照集Database snapshots No No
資料類型Data types Yes Yes
DBCC 陳述式DBCC statements 大部分 - 請參閱個別陳述式Most - see individual statements 是 - 請參閱 DBCC 差異Yes - see DBCC differences
DDL 陳述式DDL statements 大部分 - 請參閱個別陳述式Most - see individual statements 是 - 請參閱 T-SQL 差異Yes - see T-SQL differences
DDL 觸發程序DDL triggers 僅限資料庫Database only Yes
分散式分割區檢視Distributed partition views No Yes
分散式交易 - MS DTCDistributed transactions - MS DTC 否 - 請參閱彈性交易No - see Elastic transactions 否-請參閱連結的伺服器差異No - see Linked server differences
DML 陳述式DML statements Yes Yes
DML 觸發程序DML triggers 大部分 - 請參閱個別陳述式Most - see individual statements Yes
DMVDMVs 大部分 - 請參閱個別 DMVMost - see individual DMVs 是 - 請參閱 T-SQL 差異Yes - see T-SQL differences
動態資料遮罩Dynamic data masking Yes Yes
事件通知Event notifications 否 - 請參閱警示No - see Alerts No
運算式Expressions Yes Yes
擴充的事件 (XEvent)Extended events (XEvent) 部分請參閱 SQL Database 中的擴充事件Some - see Extended events in SQL Database 是 - 請參閱擴充事件差異Yes - see Extended events differences
擴充預存程序Extended stored procedures No No
檔案和檔案群組Files and file groups 僅限主要檔案群組Primary file group only 是的。Yes. 系統會自動指派檔案路徑, 而且無法在ALTER DATABASE ADD FILE 語句中指定檔案位置。File paths are automatically assigned and the file location cannot be specified in ALTER DATABASE ADD FILE statement.
FilestreamFilestream No No
全文檢索搜尋 (FTS)Full-text search (FTS) 是, 但不支援協力廠商斷詞工具Yes, but third-party word breakers are not supported 是, 但不支援協力廠商斷詞工具Yes, but third-party word breakers are not supported
函式Functions 大部分 - 請參閱個別函式Most - see individual functions 是 - 請參閱預存程序、函式、觸發程序差異Yes - see Stored procedures, functions, triggers differences
圖表處理Graph processing Yes Yes
記憶體內部最佳化In-memory optimization 是- Premium 和業務關鍵層僅限於非持續性記憶體內建物件 (例如資料表類型) 的有限支援Yes - Premium and Business Critical tiers only Limited support for non-persistent In-Memory objects such as table types 是 - 僅限業務關鍵層Yes - Business Critical tier only
JSON 資料支援JSON data support Yes Yes
語言元素Language elements 大部分 - 請參閱個別元素Most - see individual elements 是 - 請參閱 T-SQL 差異Yes - see T-SQL differences
連結的伺服器Linked servers 否 - 請參閱彈性查詢No - see Elastic query 是的。Yes. 只有在沒有分散式交易的情況下, 才SQL Server 和 SQL DatabaseOnly to SQL Server and SQL Database without distributed transactions.
從檔案讀取的連結伺服器(CSV、Excel)Linked servers that read from files (CSV, Excel) 資料分割No. 使用BULK INSERTOPENROWSET作為 CSV 格式的替代方法。Use BULK INSERT or OPENROWSET as an alternative for CSV format. 資料分割No. 使用BULK INSERTOPENROWSET作為 CSV 格式的替代方法。Use BULK INSERT or OPENROWSET as an alternative for CSV format. 受控執行個體意見專案上追蹤此要求Track this requests on Managed Instance Feedback item
記錄傳送Log shipping 每個資料庫皆隨附高可用性High availability is included with every database. Azure SQL Database 的業務連續性概觀會討論災害復原Disaster recovery is discussed in Overview of business continuity with Azure SQL Database 以原生方式內建為 DMS 遷移程式的一部分。Natively built in as a part of DMS migration process. 無法當做高可用性解決方案使用, 因為其他高可用性方法會包含在每個資料庫中, 不建議使用記錄傳送作為 HA 替代方案。Not available as High availability solution, because other High availability methods are included with every database and it is not recommended to use Log-shipping as HA alternative. 嚴重損壞修復會在Azure SQL Database 的商務持續性總覽中討論。Disaster recovery is discussed in Overview of business continuity with Azure SQL Database. 無法當做資料庫之間的複寫機制使用-在業務關鍵層自動容錯移轉群組異動複寫上使用次要複本做為替代方案。Not available as a replication mechanism between databases - use secondary replicas on Business Critical tier, auto-failover groups, or transactional replication as the alternatives.
登入和使用者Logins and users 是, 但CREATEALTER login 語句不提供所有選項 (沒有 Windows 和伺服器層級的 Azure Active Directory 登入)。Yes, but CREATE and ALTER login statements do not offer all the options (no Windows and server-level Azure Active Directory logins). EXECUTE AS LOGIN不受支援-請EXECUTE AS USER改用。EXECUTE AS LOGIN is not supported - use EXECUTE AS USER instead. 是, 但有一些差異Yes, with some differences. Windows 登入不受支援, 而且應該以 Azure Active Directory 登入來取代。Windows logins are not supported and they should be replaced with Azure Active Directory logins.
最低記錄大量匯入Minimal logging in bulk import 否, 只支援完整復原模式。No, only Full Recovery model is supported. 否, 只支援完整復原模式。No, only Full Recovery model is supported.
修改系統資料Modifying system data No Yes
OLE AutomationOLE Automation No No
線上索引作業Online index operations Yes Yes
OPENDATASOURCEOPENDATASOURCE No 是, 僅適用于其他 Azure SQL 資料庫和 SQL Server。Yes, only to other Azure SQL Databases and SQL Servers. 請參閱t-sql 差異See T-SQL differences
OPENJSONOPENJSON Yes Yes
OPENQUERYOPENQUERY No 是, 僅適用于其他 Azure SQL 資料庫和 SQL Server。Yes, only to other Azure SQL Databases and SQL Servers. 請參閱t-sql 差異See T-SQL differences
OPENROWSETOPENROWSET 是, 僅適用于從 Azure Blob 儲存體匯入。Yes, only to import from Azure Blob storage. 是, 僅適用于其他 Azure SQL 資料庫和 SQL Server, 以及從 Azure Blob 儲存體匯入。Yes, only to other Azure SQL Databases and SQL Servers, and to import from Azure Blob storage. 請參閱t-sql 差異See T-SQL differences
OPENXMLOPENXML Yes Yes
運算子Operators 大部分 - 請參閱個別運算子Most - see individual operators 是 - 請參閱 T-SQL 差異Yes - see T-SQL differences
分割Partitioning Yes Yes
PolybasePolybase 資料分割No. 您可以使用OPENROWSET函數查詢放在 Azure Blob 儲存體的檔案中的資料。You can query data in the files placed on Azure Blob Storage using OPENROWSET function. 資料分割No. 您可以使用OPENROWSET函數查詢放在 Azure Blob 儲存體的檔案中的資料。You can query data in the files placed on Azure Blob Storage using OPENROWSET function.
述詞Predicates Yes Yes
查詢通知Query Notifications No Yes
R 服務R Services 是,現已在公開預覽版中推出Yes, in public preview No
復原模式Recovery models 僅支援保證高可用性的完整復原。Only Full Recovery that guarantees high availability is supported. 簡單和大量記錄復原模式無法使用。Simple and Bulk Logged recovery models are not available. 僅支援保證高可用性的完整復原。Only Full Recovery that guarantees high availability is supported. 簡單和大量記錄復原模式無法使用。Simple and Bulk Logged recovery models are not available.
資源管理員Resource governor No Yes
RESTORE 陳述式RESTORE statements No 是, 在 Azure Blob 儲存體FROM URL上放置備份檔案的強制選項。Yes, with mandatory FROM URL options for the backups files placed on Azure Blob Storage. 請參閱還原差異See Restore differences
從備份還原資料庫Restore database from backup 僅限從自動備份 - 請參閱SQL Database 復原From automated backups only - see SQL Database recovery 從自動備份-請參閱SQL Database復原以及放在 Azure Blob 儲存體上的完整備份-請參閱備份差異From automated backups - see SQL Database recovery and from full backups placed on Azure Blob Storage - see Backup differences
將資料庫還原至 SQL ServerRestore database to SQL Server 資料分割No. 請使用 BACPAC 或 BCP, 而不是原生還原。Use BACPAC or BCP instead of native restore. 否, 因為在受控執行個體中使用的 SQL Server 資料庫引擎版本高於內部部署所使用之任何 RTM 版本的 SQL Server。No, because SQL Server Database Engine used in Managed Instance has higher version than any RTM version of SQL Server used on-premises. 請改用 BACPAC、BCP 或異動複寫。Use BACPAC, BCP, or Transactional replication instead.
資料列層級安全性Row Level Security Yes Yes
語意搜尋Semantic search No No
序號Sequence numbers Yes Yes
Service BrokerService Broker No 是, 但只能在實例內。Yes, but only within the instance. 請參閱Service Broker 差異See Service Broker differences
伺服器組態設定Server configuration settings No 是 - 請參閱 T-SQL 差異Yes - see T-SQL differences
SET 陳述式Set statements 大部分 - 請參閱個別陳述式Most - see individual statements 是 - 請參閱 T-SQL 差異Yes - see T-SQL differences
空間Spatial Yes Yes
SQL Server 代理程式SQL Server Agent 否 - 請參閱彈性工作No - see Elastic jobs 是 - 請參閱 SQL Server Agent 差異Yes - see SQL Server Agent differences
SQL Server 稽核SQL Server Auditing 否 - 請參閱 SQL Database 稽核No - see SQL Database auditing 是 - 請參閱稽核差異Yes - see Auditing differences
預存程序Stored procedures Yes Yes
系統預存函式System stored functions 大部分 - 請參閱個別函式Most - see individual functions 是 - 請參閱預存程序、函式、觸發程序差異Yes - see Stored procedures, functions, triggers differences
系統預存程序System stored procedures 部分 - 請參閱個別預存程序Some - see individual stored procedures 是 - 請參閱預存程序、函式、觸發程序差異Yes - see Stored procedures, functions, triggers differences
系統資料表System tables 部分 - 請參閱個別資料表Some - see individual tables 是 - 請參閱 T-SQL 差異Yes - see T-SQL differences
系統目錄檢視System catalog views 部分 - 請參閱個別檢視Some - see individual views 是 - 請參閱 T-SQL 差異Yes - see T-SQL differences
TempDBTempDB 是的。Yes. 每個資料庫的每個核心32GB 大小32GB size per core for every database. 是的。Yes. 適用于整個 GP 層的每個 vCore 的24GB 大小, 並受限於 BC 層的實例大小24GB size per vCore for entire GP tier and limited by instance size on BC tier
暫存資料表Temporary tables 本機和資料庫範圍的全域暫存資料表Local and database-scoped global temporary tables 本機和執行個體範圍的全域暫存資料表Local and instance-scoped global temporary tables
暫存資料表Temporal tables Yes Yes
時區選擇Time zone choice No , 而且必須在建立受控執行個體時設定。Yes, and it must be configured when the Managed Instance is created.
威脅偵測Threat detection Yes Yes
追蹤旗標 (機器翻譯)Trace flags No 是, 但只有有限的全域追蹤旗標集合。Yes, but only limited set of global trace flags. 請參閱DBCC 差異See DBCC differences
異動複寫Transactional Replication 是,僅限交易式和快照式複寫訂閱者Yes, Transactional and snapshot replication subscriber only 是, 在公開預覽中。Yes, in public preview. 請參閱這裡的條件約束。See the constraints here.
變數Variables Yes Yes
透明資料加密 (TDE)Transparent data encryption (TDE) 是 - 僅限一般用途與商務關鍵服務層級Yes - General Purpose and Business Critical service tiers only Yes
Windows Server 容錯移轉叢集Windows Server Failover Clustering 資料分割No. 提供高可用性的其他技術會包含在每個資料庫中。Other techniques that provide high availability are included with every database. Azure SQL Database 的業務連續性概觀會討論災害復原Disaster recovery is discussed in Overview of business continuity with Azure SQL Database 資料分割No. 提供高可用性的其他技術會包含在每個資料庫中。Other techniques that provide high availability are included with every database. Azure SQL Database 的業務連續性概觀會討論災害復原Disaster recovery is discussed in Overview of business continuity with Azure SQL Database
XML 索引XML indexes Yes Yes

平台功能Platform capabilities

Azure 平臺提供一些 PaaS 功能, 可新增為標準資料庫功能的額外價值。Azure platform provides a number of PaaS capabilities that are added as an additional value to the standard Database features. 有一些外部服務可與 Azure SQL Database 服務搭配使用。There is a number of external services that can be used with Azure SQL Database service.

平臺功能Platform Feature 單一資料庫和彈性集區Single databases and elastic pools 受控實例Managed instances
主動式異地複寫Active geo-replication 是-超大規模資料庫以外的所有服務層級Yes - all service tiers other than hyperscale 否, 請參閱自動容錯移轉群組 (預覽)做為替代方案No, see Auto-failover groups(preview) as an alternative
自動容錯移轉群組Auto-failover groups 是-超大規模資料庫以外的所有服務層級Yes - all service tiers other than hyperscale 是,現已在公開預覽版中推出Yes, in public preview
自動調整規模Auto-scale 是, 在無伺服器模型Yes, in serverless model 否, 您必須選擇保留的計算和儲存體。No, you need to choose reserved compute and storage.
Azure Active Directory (AAD) 驗證Azure Active Directory (AAD) authentication 是的。Yes. 僅限 AAD 使用者。AAD users only. 是的。Yes. 包括伺服器層級的 AAD 登入。Including server-level AAD logins.
Azure 資源健康狀態Azure Resource Health Yes No
備份保留Backup retention 是的。Yes. 預設值為7天, 最大值為35天。7 days default, max 35 days. 是的。Yes. 預設值為7天, 最大值為35天。7 days default, max 35 days.
資料移轉服務 (DMS)Data Migration Service (DMS) Yes Yes
檔案系統存取File system access 資料分割No. 使用BULK INSERTOPENROWSET , 從 Azure Blob 儲存體存取和載入資料, 以做為替代方式。Use BULK INSERT or OPENROWSET to access and load data from Azure Blob Storage as an alternative. 資料分割No. 使用BULK INSERTOPENROWSET , 從 Azure Blob 儲存體存取和載入資料, 以做為替代方式。Use BULK INSERT or OPENROWSET to access and load data from Azure Blob Storage as an alternative.
異地還原Geo-restore 是-超大規模資料庫以外的所有服務層級Yes - all service tiers other than hyperscale 是-使用Azure PowerShellYes - using Azure PowerShell.
超大規模資料庫架構Hyperscale architecture Yes No
長期備份保留-LTRLong-term backup retention - LTR 是, 保持自動備份最多10年。Yes, keep automatically taken backups up to 10 years. 尚未提供。Not yet. 使用COPY_ONLY 手動備份做為暫時的因應措施。Use COPY_ONLY manual backups as a temporary workaround.
暫停/繼續Pause/resume 是, 在無伺服器模型Yes, in serverless model No
原則式管理Policy-based management No No
公用 IP 位址Public IP address 是的。Yes. 您可以使用防火牆或服務端點來限制存取權。The access can be restricted using firewall or service endpoints. 是的。Yes. 需要明確啟用, 而且必須在 NSG 規則中啟用埠3342。Needs to be explicitly enabled and port 3342 must be enabled in NSG rules. 如有需要, 可以停用公用 IP。Public IP can be disabled if needed. 如需詳細資訊, 請參閱公用端點See Public endpoint for more details.
資料庫還原時間點Point in time database restore 是-超大規模資料庫以外的所有服務層級-請參閱SQL Database復原Yes - all service tiers other than hyperscale - see SQL Database recovery 是 - 請參閱 SQL Database 復原Yes - see SQL Database recovery
資源集區Resource pools 是, 身為彈性集區Yes, as Elastic pools 資料分割No. 單一受控 mnstance 可以有多個共用相同資源集區的資料庫。A single managed mnstance can have multiple databases that share the same pool of resources. 受控實例無法共用資源。Managed instances cannot share resources.
相應增加或相應減少 (線上)Scaling up or down (online) 是, 您可以在最短的停機時間內變更 DTU 或保留的虛擬核心或最大儲存體。Yes, you can either change DTU or reserved vCores or max storage with the minimal downtime. 是, 您可以在最短的停機時間內變更保留的虛擬核心或最大儲存體。Yes, you can change reserved vCores or max storage with the minimal downtime.
SQL 分析SQL Analytics Yes Yes
SQL 資料同步SQL Data Sync Yes No
SQL Server Analysis Services (SSAS)SQL Server Analysis Services (SSAS) 否, azure Analysis Services是個別的 azure 雲端服務。No, Azure Analysis Services is a separate Azure cloud service. 否, azure Analysis Services是個別的 azure 雲端服務。No, Azure Analysis Services is a separate Azure cloud service.
SQL Server Integration Services (SSIS)SQL Server Integration Services (SSIS) 是,使用 Azure Data Factory (ADF) 環境中的受控 SSIS,其中的套件會儲存於 Azure SQL Database 所裝載的 SSISDB 中,並於 Azure SSIS Integration Runtime (IR) 上執行,請參閱在 ADF 中建立 Azure-SSIS IRYes, with a managed SSIS in Azure Data Factory (ADF) environment, where packages are stored in SSISDB hosted by Azure SQL Database and executed on Azure SSIS Integration Runtime (IR), see Create Azure-SSIS IR in ADF.

若要比較 SQL Database 伺服器與受控執行個體中的 SSIS 功能,請參閱比較 Azure SQL Database 單一資料庫/彈性集區與受控執行個體To compare the SSIS features in SQL Database server and Managed Instance, see Compare Azure SQL Database single databases/elastic pools and Managed Instance.
是,使用 Azure Data Factory (ADF) 環境中的受控 SSIS,其中的套件會儲存於受控執行個體所裝載的 SSISDB 中,並於 Azure SSIS Integration Runtime (IR) 上執行,請參閱在 ADF 中建立 Azure-SSIS IRYes, with a managed SSIS in Azure Data Factory (ADF) environment, where packages are stored in SSISDB hosted by Managed Instance and executed on Azure SSIS Integration Runtime (IR), see Create Azure-SSIS IR in ADF.

若要比較 SQL Database 與受控執行個體中的 SSIS 功能,請參閱比較 Azure SQL Database 單一資料庫/彈性集區與受控執行個體To compare the SSIS features in SQL Database and Managed Instance, see Compare Azure SQL Database single databases/elastic pools and Managed Instance.
SQL Server Reporting Services (SSRS)SQL Server Reporting Services (SSRS) 否 - 請參閱 Power BINo - see Power BI 否 - 請參閱 Power BINo - see Power BI
查詢效能深入解析 (QPI)Query Performance Insights (QPI) Yes 資料分割No. 使用 SQL Server Management Studio 和 Azure Data Studio 中的內建報表。Use built-in reports in SQL Server Management Studio and Azure Data Studio.
VNetVNet 部分, 它會使用VNet 端點來啟用限制存取Partial, it enables restricted access using VNet Endpoints 是, 受控執行個體會插入客戶的 VNet 中。Yes, Managed Instance is injected in customer's VNet. 請參閱子網VNetSee subnet and VNet
VNet 服務端點VNet Service endpoint Yes No

工具Tools

Azure SQL database 支援各種資料工具, 可協助您管理資料。Azure SQL database supports various data tools that can help you to manage your data.

工具Tool 單一資料庫和彈性集區Single databases and elastic pools 受控實例Managed instances
Azure 入口網站Azure Portal Yes Yes
Azure CLIAzure CLI Yes Yes
Azure Data StudioAzure Data Studio Yes Yes
Azure PowershellAzure Powershell Yes Yes
BACPAC 檔案 (匯出)BACPAC file (export) 是 - 請參閱 SQL Database 匯出Yes - see SQL Database export 是 - 請參閱 SQL Database 匯出Yes - see SQL Database export
BACPAC 檔案 (匯入)BACPAC file (import) 是 - 請參閱 SQL Database 匯入Yes - see SQL Database import 是 - 請參閱 SQL Database 匯入Yes - see SQL Database import
Data Quality Services (DQS)Data Quality Services (DQS) No No
Master Data Services (MDS)Master Data Services (MDS) No No
SMO (機器翻譯)SMO Yes 版本 150Yes version 150
SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT) Yes Yes
SQL Server Management Studio (SSMS)SQL Server Management Studio (SSMS) Yes 18.0 版和更高版本Yes version 18.0 and higher
SQL Server PowerShellSQL Server PowerShell Yes Yes
SQL Server ProfilerSQL Server Profiler 否 - 請參閱擴充事件No - see Extended events Yes
System Center Operations Manager-SCOMSystem Center Operations Manager - SCOM Yes No

後續步驟Next steps