I forward engineer a DM Physical Model to generate a SQL database and then Complete Compare the database with original Physical Model. Since a pre-fix "dbo." is automatically added to all table names, all objects in the two models come about as different objects as indicated in the attached screen capture. How can I avoid such "noise" and make a clean results?, i.e. the same Domain name "director" and "dbo.director" should not result in any difference. (please refer the attached screen capture)
This is caused by having the Prefix Owner selected
removing the Prefix Owner from the advanced options removes the dbo. from the table names
