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

Question

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:

<image deleted>

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?

<image deleted>

Thanks in advance
Ben

Answer 1

Dear Ben,

Good day!!

I understand your concern but since it’s related to SQL Server Migration Assistant, I would like to suggest you to post your concern in the related community i.e., Welcome to the SQL Server Community (microsoft.com) to get the detailed help from the experts.

Apologies for redirecting you to a different community as the members in the category posted focus on the users with the out-of-the box concerns on SharePoint Online and have limited knowledge on in the SQL, so to get the fast and better assistance, we have redirected you to the correct community.

Appreciate your patience and understanding. Have a great day!!

Best Regards,

Sophia