Forum Discussion
SQL Server Migration Assistant: How to customize SQL for an object in MSSQL after 1st conversion
So in the picture below, I've run "Convert Schema" for the first time. For the tEntity_d object, it gave an appropriate conversion error ("object not found") After that, in the bottom right MSSQL...
The problem was, I had a trigger that wouldn't convert because it referenced a non-existent object in another database which hadn't been converted yet. Even though I deselected that trigger for conversion, when I ran the conversion, it would automatically get re-selected and then give an error on conversion. I got a popup saying the "target trigger already exists, do you want to overwrite it or skip?" (which is weird because I hadn't selected it for conversion). If I answered "skip", then everything works. Ie., I can then run "synchronize [the converted schema in SSMA memory] with the [destination MSSQL] database"