Firebird to SQL utility ToMSSQL.exe sits at 50% creating the SQL database

Wanted to post here for the benefit of all AyaNova users of this issue and how to resolve in case it happens to anyone else:

Issue:Run the Firebird to SQL utility ToMSSQL.exe
-Confirm Firebird database connection string and enter in SQL Express database connection string

  • Confirm connection and click on checkmark to begin the migration utility
  • Migration appears to just sit on the creation of the SQL database at 50% and doesn’t progress

Solution:Checked Event Viewer to find error message

Error message said "Cannot create file ‘c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\AyaNova_log.LDF’ because it already exists. Change the file path or the file name, and retry the operation.”

Solution was to navigate to the stated folder, delete the stated file and then start the Firebird to SQL utility ToMSSQL.exe again