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.

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.

• 
  

## PHP support for SQL Server

Microsoft now provides three versions of the PHP driver for SQL Server.

• 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.

Java support for SQL Server

Like PHP, Microsoft also provides multiple versions of JDBC drivers for SQL Server.

• 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.

Both versions are fourth-type JDBC drivers, which means they are pure Java drivers.

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!