Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Summary and induction of similarities and differences between SQL Azure and SQL Server

2025-04-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

SQL Azure does not fully support all the features and data types within SQL Server. The current version of SQL Azure does not support analysis services, replication, reporting services, and Service Broker.

Because SQL Azure is responsible for physical management, any statements and options that attempt to manipulate physical resources directly are blocked, such as Resource Governor, filegroup access, or some database definition language (DDL) statements about the server. In addition, server options, SQL trace tags (Trace Flag), or SQL Server Profiler, and Database Tuning Advisor cannot be set.

Overall, SQL Azure adopts a more advanced architectural design, hosted by Microsoft based on cloud, and provides scalable, multi-tenant, highly available database services. SQL Azure Database helps simplify the provisioning and deployment of multiple databases, eliminating the need for developers to install, set up, patch or manage databases. SQL Azure provides users with built-in high availability and fault tolerance without the need for actual customer management. SQL Azure Database supports TDS and Transact- SQL (T-SQL). Customers can develop on TSQL using existing technologies, and can also use relational data models corresponding to existing customer-owned database software. SQL Azure Database provides a cloud-based database management system that integrates existing toolsets and provides correspondence with customer-owned software.

The biggest difference between SQL Azure database management and SQL Server database physical management is that SQL Azure can not only automatically replicate all data to provide high availability, but also manage load balancing. When any primary database server stops working, another functioning backup database automatically takes over from the primary server, which is the function of failover. Moreover, the process is transparent to the user.

In order to provide physical management at this level, users cannot control the physical resources of SQL Azure. For example, you cannot specify the physical hard disk or filegroup where the database or index resides. Because the computer's file system cannot be accessed and all data is automatically replicated, SQL Server's backup and restore commands are not valid on SQL Azure.

If you use the backup command line of SQL Server to back up database, you will be prompted:

Statement 'BACKUP DATABASE' is not supported in this version of SQL Server.

The default SQL Azure service backs up all databases, but this backup is a physical backup, which is only 15 days old, so it is difficult to find a backup from 15 days ago.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report