SQL Server Migration Assistant Support

Does your migration team need a crash course on SSMA to learn about all of its featured offers? Whether your team needs assistance understanding SSMA’s assessment reports, using the console option, configuring command line options, or utilizing the testing tools, we will provide top-level help within our service level agreement.

While SSMA does automatically convert all database objects it recognizes, there are some objects which may be too ambiguous for SSMA to handle. However, as authors of SSMA, we have the knowledge to fully recognize the issues, and how to manually convert the code for use in SQL Server. We can also assist your teams in understanding the assessment reports SSMA generates with greater accuracy.

SSMA provides data migration capabilities for relatively small databases. As you move into deployment stages from your migration project, you may need to explore other data migration strategies due to larger databases and data synchronization needs. To help develop migration strategies and custom data movement scripts, our team uses popular data integration tools to ensure integrity throughout the project. We’ve also created powerful tools such as MySQLMigrator, DB2Migrator, OraMigrator, and Database Compare Suite which can be purchased to optimize data migrations to SQL Server.

SSMA only converts the code in the database or in ad hoc statements using the SSMA console. SSMA has no ability to extract SQL statements and procedure calls made by application code which interacts with the target database. To work around this, DB Best has a toolkit we’ve developed over the years to identify and fix application code for use in SQL Server databases. For example, if your team is looking to migrate your application’s front end from Oracle Forms to Web Applications, we have strategies to guide you through the process.

After code conversion with SSMA, functional testing becomes the priority, accounting for about 30% of the migration effort. Our in-house tools and frameworks will expedite the database migration testing process.

In order to emulate the same features in SQL Server, SSMA uses a migration extension package for the source databases. In most situations, our team can increase performance by interpreting the source object intent, and then replicating the same functionality using native features of SQL Server.

Accounting for about 14% of the migration effort is the process of database schema conversion. Our team will help your team evaluate your existing databases, applications, and database infrastructure in order to develop a robust future state architecture. From that point on, we can assist your team developing project plans using our 12-step migration methodology, ensuring success.