Retour
-
Titre
how to remove dbo pre fix added to all objects name when forward engineer physical model to SQL server database -
Description
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)
-
Cause
This is caused by having the Prefix Owner selected
-
Résolution
removing the Prefix Owner from the advanced options removes the dbo. from the table names
