How about DME Files, do they have limitations?
Situation
DME files in DATPROF Subset and Privacy is a file format to exchange metadat model.
DME is an abbriviation for Datprof Metada Export.
Sometimes you decide to create your own DME file to easily create the foreign keys in Privacy or Subset.
Very handy of course, but are there limitations?
Explanation
Yes, they have limitations
- DME Files do NOT support multiple schema's.
Having Foreingn keys tables in different schemas does not work! - All Names are always enclosed by "double quotes". If tables in your database are in Uppercase and in your DME Files they are in lowercase you will end up having problems.
- The Keywords Table, Column, ColumnPair and Relation are in CamelCase and you should stick to that!