SQL Server Migration Assistant: How to customize SQL for an object in MSSQL after 1st conversion

[BenjaminGSlade]

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 destination window (ambigously titled "SQL") I fixed the bad code (see the comment "This incompatible statement has been deleted by me"). But there's no option to save the fixed code in the to the MSSQL destination:

If I right click on tEntity_d in the bottom left "SQL Server Metadata Explorer" window, I see a "Synchronize with Database" option. Which database? The destination? When I try and run "Synchronize with Database" it asks if I want to save changes to "MsSQL SQL Editor" (the bottom right "SQL" window?). I answered "yes".

Then I get a "Database" (destination?) "Not Found" error. What does this mean?

Thanks in advance
Ben

[#2]

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"