Interoperability

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

  • A New Unified Development Experience with SQL Server Data Tools
  • SQL Azure DataSync Demo

    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.

    Related Solutions

    "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

    Resources