Release: SQL Server Migration Assistant (SSMA) v7.5

Overview SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server (see below for supported versions). What is new? Each iteration of the…


Released: Data Migration Assistant (DMA) v3.2

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 allows you to not only move your schema and data, but also uncontained objects…

4

Benchmark: Data migration to Azure SQL Database using DMA 3.2

DMA 3.2 enables schema and data migration from an on-premises SQL Server database to an Azure SQL Database. The data migration pipeline is built atop the SQL bulk copy technology and lets you quickly and reliably move data from your source database into your target database. There are many variables that can affect the performance…

0

The Migration Guide is now available for Public Preview!

We are pleased to announce Public Preview availability of a new database Migration Guide for enterprise customers, partners, and business decision makers who are interested in moving to the Modern Data Platform, for example migrating from Oracle to SQL Server or to Azure Data Services. Overview Hosted on the Microsoft Web, the Migration Guide is…


Enhance Power BI with DAX

Power BI (PBI) is a suite of business analytics tools that deliver insights throughout your organization. The ease of use and powerful features enable PBI to gain a great reception in the market since it was introduced in July 2015. You can find the latest releases, learning guide, detailed documentation as well as in-depth discussion…


Database as a Service (DaaS) Solution

Introduction “We would like to have the data flow to our clients like ‘water from the faucet” stated the customer for which this solution was designed. This on-premises (on-prem) SQL Server based application contains crucial financial data for the external clients of this customer. External clients using this solution subscribe to this data and there…


Released: SQL Server Migration Assistant (SSMA) v7.4

Overview SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server (see below for supported versions). What is new? SSMA for Oracle now…

0

Migration approach for Oracle features

This blog posting focuses on tasks associated with migrating an Oracle database to the latest version of SQL Server. If preparing for a migration requires changes to Oracle features/functionality, then it is important to carefully consider the potential impact of each change on the applications that use the database. This posting provides links to detail about workaround…

0

DEA 2.0: Telemetry and Local Audit for Database Experimentation Assistant

Database Experimentation Assistant contains an internet-enabled feature that can send telemetry information back to Microsoft. The same information is saved on your computer for Local Audit so that you can always see what information is being collected. All log files from DEA are saved in %temp%\DEA. In addition, you can decide which events get collected,…