call us toll-free +1 855 855 3600
 
Home > Technologies > SQL Server Migration Assistant (SSMA)

SQL Server Migration Assistant (SSMA)


See how you can get the most out of SSMA from the company who originally created the tool for Microsoft.

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.

SQL Server Migration Assiatant

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.

Everybody is talking about the need for a digital transformation, but how do you get there? See how our future-state architecture design can use cutting edge technology to meet your organization’s needs.

Trust the team who built the SQL Server Migration Assistant to provide you with SSMA support in migrating your Oracle, SAP ASE, IBM DB2, MySQL, and Microsoft Access databases to SQL Server or Azure SQL Database.

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.

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.

Comparing two production databases for migration or an upgrade? Now you can do this with one powerful and simple tool that every DBA and database developer needs.

Put our Microsoft SQL Server Integration Services experience to use for seamless data extraction, transformation, and loading operations of any complexity.

Perfectly orchestrate the transformation of your data and provide a wide range of analytical services with DB Best, powered by Azure Data Factory.

OraMigratorTM is an intuitive and effective solution for Oracle to SQL Server data migration. The tool transfers data from Oracle tables to existing SQL Server tables in a few easy steps.

DB2MigratorTM is an intuitive and effective assistant for DB2 to SQL Server data migration. The tool transfers data from DB2 tables to existing SQL Server tables in a few easy steps. It is simple to use and advantageous in execution.

MySqlMigratorTM is an intuitive and effective tool for MySQL to SQL Server data migration. It helps to transfer data from MySQL tables to existing SQL Server tables in a few easy steps.

Using Informatica solutions we can integrate your data from existing on-premises systems to the cloud, big data, and IoT systems smoothly and cost-effectively. Our solution architects will migrate the data accelerating time to value for your business goals.

We offer a fast and cost effective way to connect, clean and share cloud and on-premises data using the architecture that easily scales to respond to growing business requests.

We leverage a high performance parallel framework on-premises or in the cloud with improved speed, flexibility and effectiveness to build powerful data integration infrastructure. Utilizing big data and Hadoop we help our customers more efficiently access new data sources.

We can help you get the most out of Oracle Golden Gate and facilitate real-time data integration, replication, transformations, and verification in heterogeneous IT environments. So you can have extreme performance with Oracle Database integration and support for cloud environments.

Learn More


We have some great blog posts to help you use the AWS Schema Conversion Tool 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

Reference data sheet

Case Studies

Reference white paper