Test conversion from 5.40.3 to 7.0.1 Sage 100 Premium with multiple integrations. 5.40 instance and 7.0 instance are on same SQL server. This is the 2nd test migration, so MAS_XXX and MAS_SYSTEM databases currently exist in the new SQL instance. During migration test, after the copy is complete and during the post migration merge phase, receive the following:
Prepare failed with the following error: The following conversion record failed while converting SYS:\06.00.00.01:DATA:SY_SYSTEM:000000:000 - 42S01:MICROSOFT SQL SERVER NATIVE CLIENT 11.0 SQL SERVER. There is already an object named 'KPRIMARY_SY_System' in the database.
Notes: Change tracking is disabled and so is Replication. Tried renaming the index with same error results.
Thank you
Robert