1 Reply Latest reply: Feb 21, 2014 1:35 AM by Philip Stoyanov-Oracle RSS

    Updating Relational Model with new SQL Server Comments (MS_Description Extended Property)


      I have a relational model that was created using the Import Data Dictionary function from an Existing SQL Server 2008 Database. 


      The comments (as Extended Properties) for the Table and Columns show as Comments in RDBMS in the relational model, which is fine.


      The issue I am having is that when I update the Comments in the SQL Server and try to do a Synchronize back to the Relational Model, the new comments are not updated and the original comments also get deleted in the relational model.  In the compare model dialog, the source field for comments is blank.


      Any insight to this or is this a limitation with the Oracle Data Modeler tool?