Upgrade your SQL Server to scale before adding new hardware

In SQL Server Tiger team, we closely partner with our customers and partners to ensure they can successfully run and scale their Tier 1 mission critical workloads and applications on SQL Server. Based on our experience and interactions with customers, we found that most customers running older releases of SQL Server and experiencing performance and…


Released: Data Migration Assistant (DMA) v3.1

Overview Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It also allows you to not only move your schema, data, but also uncontained objects…


SQL Server Migration Assistant (SSMA) v7.3 is now available

  Overview SQL Server Migration Assistant (SSMA)  for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2 and Access lets users convert database schema to Microsoft SQL Server schema, upload the schema, and migrate data to the target SQL Server (see below for supported versions). What is new? Improved quality and conversion metric with targeted…

0

Upgrading a Replication Topology to SQL Server 2016

SQL Server Replication provides multi-faceted data movement capabilities across SQL Server releases which has been used by customers across the globe for a large number of years. When moving from one major release of SQL Server to another, replication topology upgrade has been a constant topic of lengthy discussions. In this post, we shall outline…

15

Data Migration Assistant (DMA) v3.0 is now available

Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It also allows you to not only move your schema, data, but also uncontained objects from…

0

Transactional Replication to Azure SQL DB is now in public preview.

  As announced yesterday during my presentation at Pass Summit 2015, you can now configure Azure SQL DB as a subscriber of SQL Server Transactional Replication. This new capacity of Transactional Replication is available starting with the following versions\updates of SQL Server: Community Technology Preview (CTP) 3.0 of SQL Server 2016 SQL Server 2014 Service…

1