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
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 advanceBen Read More