Forum Discussion

BenjaminGSlade's avatar
BenjaminGSlade
Copper Contributor
Aug 14, 2024

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 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

1 Reply

Sort By
  • BenjaminGSlade's avatar
    BenjaminGSlade
    Copper Contributor
    Aug 14, 2024
    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"

Resources