I have connected to some old Postgres database. This used to be Postgres 8.0, then I migrated dump to Postgres 8.2 (loosing polish characters from database objects by the way). I turned TDM, did RE on this database, and converted RE Postgres 82 model into Logical Model. I lost all comments, since comments are Comments property, and only Notes property is translated from physical to logical model.
I wrote a script that copied all Comments into Notes, merged model to Logical, saved Logical and went to sleep. This logical model will be my boilerplate for all changes, and all changes will be distributed to various versions of my system. First, I started with MS SQL 2005 (Firebird will be next… when it will be implemented…). I have merged my Logical Model into MS05 physical model, and generated DDL script. But there were no comments in the script! All, right, I wrote a script to copy Notes to Comments (something strange, in MSSQL dialog there is a Description tab, but it shows Comments property…).
Again, I generated DDL… no comments again. The Verify window informed me that there is no owner to tables, so descriptions wouldn’t be generated. Oh, yeah. TDM forgot to add dbo schema , so I did it. After all of those troubles script was finally ok.
So now Enhancement request:
- Please, add some support from moving database comments between models. Maybe adding Comments in logical model will be ok? Database comments usually contain important information, so it is not so nice to have them lost in translation… For me notes are something like “This field to be removed, it sux”, while comments should contain real description of an object.
- It is funny, that comments are labeled “Comments” or “Description”, depending on DB model…
- Please, add default schema dbo when merging from Logical to MSSQL2005.
I know that all this can be done via scripting, but … you will write such script once, while new users will have to do it by themselves…