8 June 2017 Stanislav Andrenko
One of the largest transportation companies in the United States needed to migrate their Oracle-based application to SQL Server platform. The customer’s application code had high que...
Trust the experts who built SQL Server Migration Assistant for Microsoft
DB Best developed a state-of-the-art database migration technology, which was subsequently acquired by Microsoft SQL Server group in 2005, becoming the foundation for the Microsoft SQL Server Migration Assistant (SSMA) product line. SSMA is free and can be downloaded from the Microsoft Download Center. Our experience includes all major databases, such as Oracle, Microsoft SQL Server, Sybase, Access, MySQL, and IBM DB2. Over the years, we’ve helped hundreds of our customers create cost-effective solutions for modernizing and migrating their applications to the Microsoft platform.
DB Best helped Microsoft maintain SSMA, and has provided support for the tool over the years.
Our DB Best database experts have seen it all using SSMA to help customers migrate to Microsoft SQL Server from Oracle, IBM DB2, Sybase ASE, Microsoft Access and MySQL databases. Despite some shortcomings in SSMA, our team of experts can implement workarounds to ensure converted code works correctly in SQL Server.
Our extensive experience with all major technologies gives our database experts a substantial advantage. Our app developers have experience in .NET, Java, JavaScript and various other programming frameworks. Our developers can assist you in modifying applications which connect to your databases – ensuring correct functioning after migrating to SQL Server.
Our SQL Server Migration Assistant Services
Here are some specific migration services that can help with your migration project with SSMA.
Getting Started
To get started with your migration effort using the SQL Server Migration Assistant, we recommend you begin with our Future-State Architecture Design Engagement to understand your current situation and create a roadmap for your future solutions based on SQL Server and Microsoft Azure technologies.
If you just need a hand getting the most out of SSMA, we also have our SQL Server Migration Jumpstart offer.
Learn more about our offers below.
Running outdated versions of your database engine?
If you are running outdated versions of your Oracle Database, SAP ASE (formally Sybase), IBM DB2 and other platforms, you might be running the risk of not having the latest in security and high availability features that newer versions have.
Once you hear how much Oracle, SAP, and IBM want to charge you to “true-up” your database license, you might want to consider migrating to Microsoft SQL Server with all of the latest features built-in without having to buy additional option licenses.
We’ve had hundreds of customers come to us looking for ways to better understand the migration costs and what it takes to get the most out of Microsoft SQL Server and Azure SQL Database.
We know how to accelerate the migration of your data and applications to Microsoft Data Platform to minimize your risks and costs.
Start saving money today — contact us to get started.
Contact us today
Other migration tools we use
While SSMA is a great tool for the typical migration project, sometimes you need extra tools to get the job done. Here are some of the other tools that we use for our migration projects to Microsoft SQL Server.
Contact us
Learn More
We have some great blog posts to help you use the Microsoft SQL Server Migration Assistant that we’ve built based on common problems customers have experienced while migrating their databases to Microsoft SQL Server and Azure SQL Database. For migrations of Oracle or SAP ASE (formally Sybase) to SQL Server, check out the white papers that our team of experts wrote for Microsoft.
Blog posts
Comprehensive Java app upgrade while migrating to SQL Server
Enhancing SQL Server database performance by 3x acceleration of queries execution
6 July 2017 Stanislav Andrenko
A leading provider of business management solutions currently hosts many of their workloads using SQL Server databases on Azure. They faced a number of SQL Server database performanc...
Helping our customer to convert Oracle schemas with hierarchical queries to SQL Server
20 June 2017 Andrey Ivanov
One of the world’s largest information technology companies decided to migrate their Oracle database to SQL Server. They leveraged SQL Server Migration Assistant (SSMA) for Oracle to...
How to determine Oracle migration ROI for complex systems
6 September 2017 Bill Ramos
A global pharmaceutical company has been supporting hundreds of applications on the Oracle platform. Their complex system became outdated over the years with 90% of end of life or exte...
Improving the web app performance while migrating from DB2 to SQL Server
4 May 2017 Stanislav Andrenko
One of the largest life insurance companies in the United States supported a reporting application. Their system included Java based web app and Informatica data management solution c...
Migrate Sybase ASE databases to SQL Server for a security technologies company
25 August 2017 Bill Ramos
DB Best recently completed a project to migrate Sybase ASE databases to SQL Server for a global leader in security technology. Faced with skyrocketing license costs with SAP to renew t...
Migrate Sybase Java applications to SQL Server for content services provider
4 October 2016 Bill Ramos
A leading provider of content services for the legal industry looked to DB Best to help them modernize their aging Sybase ASE and IQ solutions that were built on top of an old IBM AIX ...
Migrating Oracle database to SQL Server for a leading US healthcare company
17 March 2017 Stanislav Andrenko
One of the leading US healthcare organizations needed to upgrade their health record system in an effort to drive down costs while enabling new capabilities. We replaced the customer's...
Moving Oracle Forms to The Web as a Part of Database Migration Project
16 May 2017 Andrey Ivanov
A government healthcare organization wanted to move their Oracle Forms to a modern web-based UI. We offered to migrate their source Oracle database to SQL Server while converting the d...
Oracle to Azure SQL Database shift may save up to $1 million
16 June 2017 admin
‘Low-performing and costly’ - these were major characteristics of the Oracle system of one of our customers, a leading US automotive corporations. In this regard, it was quite natu...
Quick and easy automatic approach to database conversion
12 May 2017 Stanislav Andrenko
One of the largest US educational organizations has been running their data handling system in Oracle environment. They wished to reduce maintenance costs due to expensive Oracle licen...
Remote migration from Oracle to SQL Server using SSIS
4 May 2017 Stanislav Andrenko
A global financial software provider needed to migrate their billing solution from Oracle to SQL Server for one of their strategic clients located at the other end of the world. The ac...
SSMA for Oracle 7.0 — Overview of Data Migration Features
5 December 2016 Bill Ramos
DB Best uses a 12-step migration process to make sure all bases are covered as part of a typical migration project. Data migration is a critical part of a database migration projects a...
SSMA for Oracle 7.0 — What's New — Migrating to SQL Server 2016 Temporal Tables
2 September 2016 Bill Ramos
The new version of SQL Server Migration Assistant (SSMA) 7.0 now supports direct migration to several new features introduced in SQL Server 2016. One of these new features is the direc...
SSMA for Oracle 7.0 — What’s New — Using In-Memory OLTP in SQL Server 2016
14 October 2016 Bill Ramos
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 databa...
SSMA for Oracle 7.0 — What’s New — Using Row-Level Security in SQL Server 2016
15 September 2016 Bill Ramos
This continues our video blog series about new features, that are implemented in the new version of SQL Server Migration Assistant 7.0. And now we will talk about some important secur...
Using Sybase SQL Server application unification to reduce migration risks
14 March 2017 Bill Ramos
A financial service software provider needed to upgrade their customer facing applications to SQL Server while keeping their Sybase ASE database. Our Sybase SQL Server Application Unif...
Oracle to SQL Server migration with SSMA: How to convert cursor or cursor variable as a function or procedure call parameter
9 March 2017 Bill Ramos
Oracle 9i introduced the predefined SYS_REFCURSOR type meaning we no longer have to define our own REF CURSOR types. SQL Server doesn’t support SYS_REFCURSOR type and doesn’t have ...
Oracle to SQL Server migration with SSMA: How to convert foreign keys with different types of columns and referenced columns
9 March 2017 Bill Ramos
Oracle allows you to create foreign key for table using columns with different data types. But SQL Server Migration Assistant (SSMA) for Oracle cannot convert them to SQL Server correc...
Oracle to SQL Server migration with SSMA: How to convert materialized view with float type
24 March 2017 Bill Ramos
SQL Server has several different ways of implementing the same behavior as an Oracle materialized view. SSMA cannot understand the original optimization reason for why the application ...
Oracle to SQL Server migration with SSMA: How to convert Unparsed SQL — Pivot Operator
9 March 2017 Bill Ramos
Oracle 11g introduced pivot operation that allows writing cross tabulation (also called transposed, crosstab and matrix) queries that rotate rows into columns and aggregate results. Pi...
Oracle to SQL Server migration with SSMA: How to convert unsupported SQL clause
13 June 2017 Andrey Ivanov
Oracle allows you to assign a non-scalar condition in WHERE clause. The problem is that SQL Server doesn't support conditions of this type. Thus, the SQL Server Migration Assistant (...
Oracle to SQL Server migration with SSMA: How to convert unsupported table expressions
9 March 2017 admin
Oracle's table functions allow you to define a set of PL/SQL statements that will, when queried, behave just as a regular query to the table. You may use the table function to manipula...
Oracle to SQL Server migration with SSMA: How to convert virtual columns
14 June 2017 Andrey Ivanov
Oracle allows you to specify virtual columns in the table definition. Oracle doesn't store the data in virtual columns on the disk. On the contrary, the database derives the values i...
Reference data sheet
Oracle to SQL Migration
21 September 2016 Bill Ramos
Leveraging Microsoft SQL Server, DB Best can help Oracle customers achieve the performance, scale, and security that their mission-critical applications require while keeping costs und...
Sybase to SQL Server Migration Datasheet
23 September 2016 Bill Ramos
The number one reason businesses want to migrate from Sybase to SQL Server is reducing Total Cost of Ownership. The DB Best team developed a unique methodology for migrating Sybase app...
Modernizations to Microsoft's Data Platform
21 September 2016 Bill Ramos
Cloud services such as Microsoft Azure, coupled with database technologies like SQL Server, enable organizations to quickly create and scale solutions that solve challenges and fuel ne...
Case Studies
Migrating critical apps from Sybase ASE to SQL Server
30 August 2016 Bill Ramos
Our client, a global leader in security technology, had two mission-critical yet aging PowerBuilder applications running against Sybase ASE that were out of compliance given the lack o...
Reference white paper
Guide to migrating from Oracle to SQL Server and Azure SQL Database
8 October 2015 Bill Ramos
This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2014. It describes the implementation differences of database objec...
Guide to migrating from Sybase ASE to SQL Server 2014 and Azure SQL Database using SSMA
15 November 2015 Bill Ramos
Summary: This white paper covers known issues for migrating Sybase Adaptive Server Enterprise database to SQL Server 2014. Instructions for handling the differences between the two pla...
Request a quote