Migration from Sybase ASE using SSMA CLI


Recently I learned a lesson through multiple testing around SSMA for Sybase. Let’s suppose you need to migrate your data from Sybase ASE to SQL Server. You could use the SSMA GUI tool to connect to both destinations and select schemas or objects to convert and migrate. Now what if you needed to automate this process?

 

You can use SSMA for Sybase. This tool includes a CLI (Command Line Interface) version that allows you to run assessment reports, converts ASE database objects to SQL Server database objects and then migrates data like the GUI version. I found this very