Why did I waited for it? Because of, for instance, these bug fixes:
27245333 – IMPORT OF DDL AS ORACLE 12CR2 DOESN’T RECOGNIZE DATA TYPES
27182476 – SQL SERVER 2012 DDL GENERATION FAILS WITH CLASS CAST EXCEPTION
26985782 – STANDARD REPORT – COLUMN DATA TYPE IS NOT INCLUDED WHEN COLLECTION
27040952 – DESIGN PROPERTIES DIALOG DOESN’T WORK
26988362 – IMPORTING LEGACY PHYSICAL MODEL RESULTS IN TABLE ITEMS LISTED RED IN HIERARCHY
27041167 – REVERSE CLAUSE FOR INDEX IS NOT PROCESSED DURING IMPORT FROM DATABASE
26918584 – SYNC TO DB CANNOT RECOGNIZE TABLES WHEN PROXY USER IS USED
26919656 – PROBLEMS WHEN EDITING UDP FOR ATTRIBUTES IN ENTITY DIALOG
26750611 – INVALID INSERT STMT ON ‘USE QUOTED IDENTIFIERS’ CHECKED AT DDL PREVIEW SCRIPT
26920080 – “INCLUDE SCHEMA IN DDL” SETTING IS NOT CONSIDERED FOR PROCEDURES
26932946 – ANNOYING BEHAVIOR WHEN CREATING COLUMNS
Why would I define the Default System Types Directory in Preferences?
If that directory has been defined you do not need to worry about domains etc. when upgrading Data Modeler. All the system type kind of things are automatically available even though you upgrade.Things like:
I have defined the Naming Standards, Templates etc for one design and I would like to have those same settings for another design I am working on. How can I do that?
You can do that using the Export/Import functionality. Open the design that has the right settings. Go to either Design Properties or Design Level Settings and select Export.
Save the file. Remember to add the extension xml.
Open the design you want to implement those settings. Select Import and find the file with the exported settings. Press Open. Now the Design Properties/Design Level Settings are the same as in the original design.
I am sure you remember there are Preferences and Design Properties in Data Modeler. Preferences affect all the designs in a Data Modeler installation (in that computer) whileas Design Properties affect only that design they are defined for.
Now in Data Modeler 17.3 you can find those Design Properties also under Tools menu by a name Design Level Settings:
These are the sames you can still find under Design Properties too and you should definitely check them (either under Design Properties or Design Level Settings), because they are important.
I just upgraded Data Modeler to the latest release/installed Data Modeler to a new computer but all my domains are gone. Is there any way to get them back or do I need to define them manually again? Of course there is a way!
Select File, Import, Domains.
Then find the file your domains are saved to using Open Domain File.
I always define columns like USER_CREATED, USER_MODIFIED, DATE_CREATED, DATE_MODIFIED for my tables but I would not like to design them in the logical model. Is there a way to get them automatically to the relational model? YES!
Here’s my logical model. None of my entities has those attributes defined.
First design a table that only has those technical columns, nothing else. In my example a table is called TempTable:
Then when Engineering to Relational Model select General Options, Use Template Table and select this table from the list:
Now all the tables you just generated to a relational model has these columns:
Read Full Article
Scroll to Top
Separate tags by commas
To access this feature, please upgrade your account.