Using AWS Schema Conversion Tool Extension Pack for Data Warehouses
28 Apr 2017

When migrating to Amazon Redshift, you need a way to convert functions and other capabilities that Oracle, Teradata, Greenplum, Netezza support that Redshift does not natively support. The AWS Schema Conversion Tool Extension Pack for Data Warehouses provides Python based libraries to provide the same functionally with Redshift. In this post, we will show how the AWS Schema Conversion Tool (SCT) generates the extension packs to help in your migration effort. You will have to upload the extension pack for your source database which includes the functions from the user-defined Python libraries to S3 storage. In the following video, we demonst...

How to revive deprecated Oracle Reports
24 Apr 2017

A large European company decided to migrate their Oracle database system to SQL Server. Of course, they wanted to outmaneuver the performance of their original system. The original customer’s system included a huge bunch of over 700 reports, built in deprecated Oracle forms technology. We offered a solution on the new SQL Server Reporting Services platform. This solution satisfied the rigid performance demands of the customer. We used the previously developed internal tool to automate the Oracle Forms conversion process, but after all, we performed a lot of manual edits. Learn more about the technical background of this project from the f...

Oracle to SQL Server migration with SSMA
Oracle to SQL Server migration with SSMA: How to convert aggregate functions referring to remote table
21 Apr 2017

Oracle allows you to create a query with aggregate functions referring to a remote table. For example, if your query includes two tables: one from the local schema and another from the remote database. You can simply use a database link in Oracle to create that construction. Previously, we already talked about converting database links using a linked server. But the problem is that SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert queries that refer to the remote objects through the database link. So, when you try to convert a query with aggregate functions referring to a remote table, SSMA will generate an error O...

Oracle to SQL Server migration with SSMA: How to convert database links
13 Apr 2017

Oracle uses database links to access objects on another database. In SQL Server you can use linked server or an OPENQUERY function to emulate that functionality. The problem is that SQL Server Migration Assistant (SSMA) for Oracle doesn’t automatically convert database links. Instead, when you try to convert a query that refers to the remote objects through the database link, SSMA will generate an error O2SS0083. (more…)...

Change Data Capture for SQL Server Table Replication
Using Change Data Capture for SQL Server Table Replication
06 Apr 2017

A major bank in Europe that we’ve been working with over the years requested our help in upgrading SQL Server 2008 to 2016. Since we performed the migration process originally from DB2 to SQL Server we had a deep knowledge of the customer’s data. Because of the need to have a highly available system and they could not afford to be down. Our client needed a way to downgrade to the old database system in case something bad happens to the upgraded system. Also, our customer wanted to include the disaster recovery solution. We proposed a solution that would allow them to use SQL Server table replication from the upgraded database...

Azure SQL Database Migration to Embrace Cloud Benefits
06 Apr 2017

One of the leading medical software providers maintained their complex healthcare system with thousands of unique users. Developing over time, this system became overloaded and unsafe. So our customer contacted us to update their system in order to meet the HIPAA standards. After thorough research, we came up with a decision to migrate their databases from SQL Server 2008 to Azure SQL Database. As a result, the customer benefited tremendously from enabling modern high availability and disaster recovery facilities, with better visibility and control of their cost. Check how we have migrated the custom databases to Azure environment in the...