Migrate audit data from mysql to SQL Server

Products

• CA API Gateway

Issue/Introduction

There's a plan to store audit information to an external SQL Server database configured with audit sink. Before completing this configuration,  the audit information stored in the internal MySQL DB needs to be migrated to the new SQL Server database.

Is there a procedure that could be used for this audit data migration?

Environment

API Gateway: 10.X

Resolution

We don't have a process for migrating data from MySQL to other database platforms.