SSMA for Oracle 7.0 — What’s New — Using In-Memory OLTP in SQL Server 2016
14 Oct 2016

This continues our video blog series about new features on the new capabilities of SQL Server Migration Assistant 7.0. SQL Server 2016 In-Memory OLTP significantly improves OLTP database application performance and allows running large queries against the same tables using clustered and non-clustered columnstore indexes. This technology was introduced in SQL Server 2014 and now SSMA 7.0 supports migrating Oracle Database In-Memory tables to In-Memory OLTP with SQL Server 2016. Background on SQL Server In-Memory OLTP and Oracle Database In-Memory SQL Server 2016 In-Memory OLTP is a high performance, memory-optimized engine, designed for modern...

Database Compare Suite 4.5 Released — Amazon Redshift and SQL Server 2000 support
12 Oct 2016

We are proud to announce the latest version of the Database Compare Suite tool, which now adds support for Amazon Redshift and SQL Server 2000. For customers looking to upgrade their SQL Server 2000 database servers, Database Compare Suite is the only tool on the market that supports comparing database schema and data changes with newer versions of SQL Server. This a great timesaver for your upgrade projects! Eight database dialects are now supported in Database Compare Suite. They include: Amazon Redshift, Microsoft Azure SQL Database, IBM DB2, Microsoft SQL Server, MySQL, Oracle, PostgreSQL and Sybase ASE. This means that there are 36 pairs...

Converting Objects during Database Migration using AWS Schema Conversion Tool
11 Oct 2016

This continues our video blog series on the AWS Schema Conversion Tool (SCT). We will demonstrate how the AWS SCT helps users convert data and code objects from Oracle database to AWS RDS for MySQL, Amazon Aurora or PostgreSQL database. Background Converting Objects is one of the most important aspects in the AWS Schema Conversion Tool application. The AWS Schema Conversion Tool allows users to convert all objects in the database, or simply select the required objects and convert them (as you already know, the Assessment Report is automatically generated for each pair of converted objects). As far as not all objects being automatically conver...