Data Modeller: compare models
Hello, when i go through the compare models dialog. The table columns are highlighted as been different. Inspection revels that the difference is in the data type: On the source model it is set to the domain presentation and on the target - to it's a logical type representation. I'm not sure how to change this? Another question: same dialog - the length of varchar is shown in chars on target and in bytes on the target. Where do i need to change this ? thank you Andrew Edited by: AndrewZ on Jan 11, 2010 12:19 PM
Hello Andrew, how did you create these models - with domains and without and that char - byte difference? Look at "General options">DDL - there are two settings that could help: - "Show char/byte unit...." - "Use data type kind ..." - it's related to domain/ logical type difference; also, you can create domains in model without domains - use Tools>"Types to domains wizard". Philip
Hello Philip, "how did you create these models - with domains and without and that char - byte difference?"i created a logical model using domains. Each domain has been defined in the "domain administration" dialog and mapped to logical type with ( in case of char/varchar types ) "char" length. For example : loan_id is specified as "domain (short text)". Which is defined ( in "domains administration" ) as char(50). After logical model was complete, i generated the relational , did "DDL generation" ran the script in the DB. After that i made some changes to the logical ( added and changed some entities ). To generate the diff i followed Sue's tutorial. These were the steps I used to get to this situation. So now i have ( in "Compare Models" dialog) the situation that all tables are different, and the difference is in a type presentation. Here is the link to the screenshot i made. "also, you can create domains in model without domains"hmmm, what would be an advantage of using this approach? Thank you Andrew Edited by: AndrewZ on Jan 10, 2010 7:04 PM
EA 2.1 desc of object type doesnt display correct result
BUG: EA 2.1 code editor: completion insight doesn't work in opened files
Edit table dialog with inherited privileges
Unable to see the schema tables ..
EA2 Export query results causes query to be executed again
v1.5.5 prompts for bind vars when SQL contains timestamp literal
EA2 - MacOSX - Settings not migrated from 1.5
EA2 - Dates not displaying times
01017 Invalid username/password; login denied; Error in v1.5, works in v1.2
Line Break After Semi-Colon?
query output similar to sql plus results
EA2 - EA1 - Connection interface is unavailable
Auto commit DDL: Difference between SQL developer and SQL*Plus?
Unable to do case-insensitive string comparison using NLS in SQL Developer
Read only user access