Data Driver

Blog archive

Microsoft Encourages Oracle Migrations to SQL Server 2014

Microsoft yesterday unveiled an updated SQL Server Migration Assistant (SSMA) to ease moving existing Oracle databases to SQL Server 2014.

It's the latest back-and-forth effort between the two companies to help users of competitors' RDBMS products switch to each company's own offering.

The free SSMA tool was announced on the TechNet SQL Server Blog.

"Available now, the SSMA version 6.0 for Oracle databases greatly simplifies the database migration process from Oracle databases to SQL Server," Microsoft said. "SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce risk of database migration projects."

SQL Server 2014 -- officially released in April -- features a new, much-publicized in-memory OLTP capability, and the new SSMA for Oracle can automatically move Oracle tables into SQL Server 2014 in-memory tables. Microsoft said SSMA can process up to 10,000 Oracle objects in one migration and boasts increased performance and report generation.

The new tool supports migrations of Oracle 9i databases and later to SQL Server 2005 editions and later. It's now available for download.

In addition to the in-memory OLTP capability, SQL Server 2014 features in-memory columnstore to boost query performance and hybrid cloud-related features such as the ability to back up to the cloud directly from SQL Server Management Studio. Microsoft also touted its ability to use the Microsoft Azure cloud as a disaster recovery site using SQL Server 2014 AlwaysOn. SQL Server 2014 is available for evaluation.

Oracle: your turn.

Posted by David Ramel on 07/25/2014 at 9:44 AM


comments powered by Disqus

Featured

  • How to Do Machine Learning Evolutionary Optimization Using C#

    Resident data scientist Dr. James McCaffrey of Microsoft Research turns his attention to evolutionary optimization, using a full code download, screenshots and graphics to explain this machine learning technique used to train many types of models by modeling the biological processes of natural selection, evolution, and mutation.

  • Old Stone Wall Graphic

    Visual Studio Code Boosts Java Dependency Viewer

    Easier management of project code dependencies and improvements to extensions for popular Java frameworks and runtimes highlight the February update to Java in Visual Studio Code functionality.

  • Blule Squares

    Visual Studio 2019 for Mac 8.5 Preview Adds ASP.NET Core Authentication

    Microsoft, after shipping Visual Studio 2019 for Mac v8.4 with support for ASP.NET Core Blazor Server applications last month, is now previewing the v8.5 series, adding new authentication templates for ASP.NET Core along with other improvements.

  • Q&A with Brice Wilson: What's New in Angular 9

    We caught up with expert web developer/trainer Brice Wilson to get his take on Angular, which always appears at or near the top of periodic rankings of the most popular JavaScript-based web development frameworks.

  • Entity Framework Core Migrations

    Eric Vogel uses code samples and screenshots to demonstrate how to use Entity Framework Core migrations in a .NET Core application through the command line and in code.

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.

Upcoming Events