Interoperability

Organizations need to modernize their infrastructure and extend virtually any data anywhere.

SQL Server is an enterprise-class solution that enables interoperability and helps developers build secure, highly available, and high performance applications in .NET, C/C++, Java and PHP, on-premises and in the cloud.

What's New in SQL Server 2012

  • Develop for major platforms, such as C++, .NET, Java and PHP.
  • Deploy middle-tier applications on heterogeneous platforms that deliver rich connectivity across non-Windows environments, such as Linux.
  • Simplify the development, deployment, and management of database applications across on-premises and in the cloud.
  • Simplify complex programming tasks with T-SQL enhancements and improved support for ANSI SQL standards.

Key Capabilities

  • Build Secure, Highly Available, High Performance Application

    Rely upon a powerful array of application connectivity options that span multiple developer tools, frameworks, and languages.

    Experience Open Development Support
    • Build data-driven applications with Visual Studio, across all .NET languages such as C# and VB.NET using ADO.NET.
    • Use a wide range of development technologies such as the .NET Entity Framework to quickly build applications powered by SQL Server.
    • Gain SQL Server and SQL Azure access from any Java application using the latest JDBC Driver for SQL Server. Learn more.
    • Take advantage of the Microsoft PHP Driver for SQL Server version 3.0, including Buffered Queries and SQL Server AlwaysOn. Learn more.
    • Allow C and C++ applications to leverage the standard ODBC API and connect to SQL Server 2012 using the SQL Server ODBC Driver for Linux. Learn more.
    • Provide greater flexibility for database admins and developers who have applications that run on Linux and co-exist in SQL Server.
  • Span Private, Public and Hybrid Cloud Scenarios

    Benefit from using a common set of tools and an open programming model across private and public cloud environments.

    Integrate Private and Public Clouds
    • Deploy across on-premises and the Windows Azure public cloud.
    • Develop and manage using common, integrated tools, such as SQL Server Data Tools and SQL Server Management Studio.
    • Build powerful hybrid cloud solutions, so that applications and databases can span both on-site and public cloud resources.
    • Synchronizing databases across on-site and the Windows Azure public cloud using SQL Azure Data Sync.
    • Easily migrate databases from on-premises to the Windows Azure SQL Database public cloud using the Windows Azure Import Export Service.
  • Enjoy the Security of Standards Compatibility

    SQL Server 2012 provides ANSI-compliant SQL query capabilities for broad compatibility with other database engines.

    The SQL Standard Support You Can Rely On
    • Simplify complex programming tasks and ease database migrations with improved support for ANSI SQL standards.
    • Easily design for fault tolerance by limiting external dependencies for contained databases.
    • Benefit from enhanced support for spatial data including new shapes and methods to better support innovative location-aware applications.

"The stronger integration and interoperability of Microsoft tools cut staff training costs, minimize upgrade-compatibility problems, reduce maintenance costs, and improve customer service.”

Elena Balitsky
Team Leader, Database Administration Group