Latest updates about SQL Server
Microsoft's SQL Server team released a number of small updates last month. Notable ones include: Power BI for on-premises servers, System Center support for SQL Server 2014, and updates to Java/PHP drivers. But the first thing to focus on is the Microsoft migration tool for DB2 users.
SQL Server Migration Assistant for DB2
Microsoft's SQL Server Migration Assistant for DB2 (SQL Server Migration Assistant for DB2) recently released version 6.0. The tool claims to "automate all aspects of migration work, including migration assessment analysis, schema and SQL statement conversion, and data migration."
SSMA for DB2 v6.0 is designed to support everything from DB2 (DB2 on z/OS versions 9.0 and 10.0 and DB2 on Linux/Unix/Windows versions 9.8 and 10.1) to SQL Server 2012, SQL Server 2014 and Azure SQL DB.
Since DB2 provides some features that are not available in SQL Server, this tool also adds additional functionality to SQL Server to help it emulate DB2. Unfortunately, there is no documentation for these special features yet.
SQL Server Migration Assistant is also available for MySQL, Oracle, Sybase and Access. You can find more information on migrating from these database engines by reading the SSMA team’s blog.
Power BI
The definition of Power BI is incomplete, but broadly speaking, it is a series of business intelligence tools provided through Excel and Office 365. In addition to general charts and reports, it includes a natural language query engine designed to allow non-technical users to perform relevant queries on the data.
The newly released Power BI Analysis Services Connector allows you to connect local instances of Power BI and SQL Server Analysis Services together. To use this connector, you first need to establish Active Directory synchronization between your Azure and on-premises Active Directory.
System Center Operation Management Console
Users of the System Center Operations Management Console can now "discover and manage" SQL Server 2014 instances using the Management Pack for SQL Server 2014. This management pack is only available for SQL Server 2014. For SQL Server 2005 to 2012, another package is required.
## PHP support for SQL Server Microsoft now provides three versions of the PHP driver for SQL Server.New features
For SQL Server 2014 products, the mirror management scenario has been added
SPN Monitor now has a "search scope" parameter that allows end users to choose between LDAP and global directories.
Added fixed timeout bug in CPU tool monitoring scenario
You can now monitor the SQL Server instance on the same server using its own network interface and default port.
SQL Server instances with underscores or other special symbols under their names can be monitored.
improve
The dependency on the SQL Server Library Management Pack has been removed
Supports CPU local performance counters and logical disk indicators
Discover the SQL Server Integration Services Monitoring Seed
Move SQL Server Integration Services to a standalone management pack
Support SQL Server non-default port
Optimized performance collection replaced with raw performance collection to guarantee accuracy of hourly and daily aggregated data.
- Version 3.1 requires PHP 5.4.32 or PHP5.5.16 or above, and SQL Server 2008 or above.
- Version 3.0 requires PHP 5.3.0 or above (5.3.6 or above recommended) version
- Version 2.0 requires PHP 5.2.4 or above (5.2.13 or above recommended), and SQL Server 2005 or above. This version does not work on PHP 5.4.
- Version 4.1 supports SQL Server 2008 and above, and works with Java development kits 5.0, 6.0 and 7.0.
- Version 4.0 supports SQL Server 2005 and above, and works with Java development kits 5.0 and 6.0.
The above is the detailed content of Latest updates about SQL Server. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
What software is microsoft sql server?
Feb 28, 2023 pm 03:00 PM
Microsoft SQL Server is a relational database management system launched by Microsoft. It is a comprehensive database platform that uses integrated business intelligence (BI) tools to provide enterprise-level data management. It is easy to use, has good scalability, and has a high degree of integration with related software. High advantages. The SQL Server database engine provides more secure and reliable storage functions for relational data and structured data, allowing users to build and manage highly available and high-performance data applications for business.
SQL Server or MySQL? New research reveals the best database choices.
Sep 08, 2023 pm 04:34 PM
SQLServer or MySQL? The latest research reveals the best database selection. In recent years, with the rapid development of the Internet and big data, database selection has become an important issue faced by enterprises and developers. Among many databases, SQL Server and MySQL, as the two most common and widely used relational databases, are highly controversial. So, between SQLServer and MySQL, which one should you choose? The latest research sheds light on this problem for us. First, let
PHP and SQL Server database development
Jun 20, 2023 pm 10:38 PM
With the popularity of the Internet, website and application development has become the main business of many companies and individuals. PHP and SQLServer database are two very important tools. PHP is a server-side scripting language that can be used to develop dynamic websites; SQL Server is a relational database management system developed by Microsoft and has a wide range of application scenarios. In this article, we will discuss the development of PHP and SQL Server, as well as their advantages, disadvantages and application methods. First, let's
A brief analysis of five methods of connecting SQL Server with PHP
Mar 21, 2023 pm 04:32 PM
In web development, the combination of PHP and MySQL is very common. However, in some cases, we need to connect to other types of databases, such as SQL Server. In this article, we will cover five different ways to connect to SQL Server using PHP.
How to connect to a Microsoft SQL Server database using PDO
Jul 29, 2023 pm 01:49 PM
Introduction to how to use PDO to connect to a Microsoft SQL Server database: PDO (PHPDataObjects) is a unified interface for accessing databases provided by PHP. It provides many advantages, such as implementing an abstraction layer of the database and making it easy to switch between different database types without modifying a large amount of code. This article will introduce how to use PDO to connect to a Microsoft SQL Server database and provide some related code examples. step
SQL Server and MySQL compete, how to choose the best database solution?
Sep 10, 2023 am 08:07 AM
With the continuous development of the Internet, database selection has become increasingly important. Among the many databases, SQLServer and MySQL are two high-profile options. SQLServer is a relational database management system developed by Microsoft, while MySQL is an open source relational database management system. So how to choose the best database solution between SQLServer and MySQL? First, we can compare these two databases in terms of performance. SQLServer is processing
SQL Server vs. MySQL: Which database is more suitable for high availability architecture?
Sep 10, 2023 pm 01:39 PM
SQL Server vs. MySQL: Which database is more suitable for high availability architecture? In today's data-driven world, high availability is one of the necessities for building reliable and stable systems. As the core component of data storage and management, the database's high availability is crucial to the business operation of the enterprise. Among the many databases, SQLServer and MySQL are common choices. So in terms of high availability architecture, which database is more suitable? This article will compare the two and give some suggestions.
SQL Server vs. MySQL comparison: Which one is better for large-scale data processing?
Sep 09, 2023 am 09:36 AM
SQLServer and MySQL are currently two very popular relational database management systems (RDBMS). They are both powerful tools for storing and managing large-scale data. However, they have some differences in handling large-scale data. This article will compare SQL Server and MySQL, focusing on their suitability for large-scale data processing. First, let us understand the basic characteristics of SQLServer and MySQL. SQLServer is developed by Microsoft
