SQL Examiner Suite for Cross Database Migration

SQL Examiner Suite for Cross Database Migration

SQL Examiner Suite for Cross Database Migration

Usually when it comes to database migration these days, you are moving to the cloud. Top cloud vendors provide utilities and incentives to ease that process. What if you want to switch databases to save on premium licensing costs? For example, migrate an Oracle database to MySQL. What if you develop software that needs to support multiple target database environments such as Oracle, SQL Server, MySQL and so on. Those are ideal use cases for a cross database utility .

Most of the popular database migration and synchronization utilities in the market today only support a single database vendor type. There seem to be only a few truly enterprise quality, cross database migration solutions that can translate schemas and synchronize data between different types of databases.

Recently I tested replication solutions, ETL and migration utilities starting with open source MySQL Workbench . I liked the price – free. I also like the simple wizard. However, I found it to be terribly slow and buggy. I could not complete migration of a tiny demo AdventureWorks database on my fancy 32GB RAM development laptop. Thus I looked for alternative solutions for database migrations.
SQL Examiner Suite

Read Also:
Your next doctor, powered by artificial intelligence

One of the best solutions at a reasonable cost that I tested was SQL Examiner Suite by SQL Accessories. Historically in SQL Server realm, SQL Examiner has received good reviews and impressive, big name client references hidden at the very bottom of their web site.
Being an avid solution tester, I wanted to give SQL Examiner a try. Here are my impressions and notes from a “hands on” review. All in all, I really liked it and will use it in the future myself. As cloud gets adopted and pricing becomes more competitive, I am betting that there will be more migrations of software and databases. In the meantime, even small companies that want to reduce database licensing costs can benefit from moving to less expensive MySQL that has come a looooooooong way since I first learned it fifteen years ago.

Installing SQL Examiner Suite was quick and easy. The software design quality and user experience were strong. I was impressed by the cross database migration support for the following databases including raw back up files.
Microsoft Access
OLE DB or ODBC databases
Database back up files

Read Also:
Ten “Design First” Principles from Strata/Hadoop World NYC

SQL Examiner’s schema and data migration was both fast and accurate. The data compare with source and target backup files was nice. I also appreciated customization of migration templates for data filtering, ignoring what to compare and script generation styles.



Data Science Congress 2017

5
Jun
2017
Data Science Congress 2017

20% off with code 7wdata_DSC2017

Read Also:
How to hire for the right big data skill set

AI Paris

6
Jun
2017
AI Paris

20% off with code AIP17-7WDATA-20

Read Also:
How to hire for the right big data skill set

Chief Data Officer Summit San Francisco

7
Jun
2017
Chief Data Officer Summit San Francisco

$200 off with code DATA200

Read Also:
Turning big data challenges into opportunities

Customer Analytics Innovation Summit Chicago

7
Jun
2017
Customer Analytics Innovation Summit Chicago

$200 off with code DATA200

Read Also:
How to hire for the right big data skill set

HR & Workforce Analytics Innovation Summit 2017 London

12
Jun
2017
HR & Workforce Analytics Innovation Summit 2017 London

$200 off with code DATA200

Read Also:
Top 8 Free and Open Source Business Intelligence Software
Read Also:
Data governance in action

Leave a Reply

Your email address will not be published. Required fields are marked *