DB2DBML - SQL Server - No description on Table

[MisterGeek]

Before using the automatic generation of the DBML file for SQL server, I had queries allowing us to generate our file in DBML format.
In these scripts, I retrieved the description table, which was very useful when viewing tables in dbdocs
Exemple :

Table "dbo"."B_BATCH_PLANIF" {
  "BBPL_ANNEE" numeric(14,2)
  "BBPL_AV_ANNEE" nvarchar(60) [note: 'Mode CRON : Annee(s)']
  "BBPL_AV_HEURE" nvarchar(10) [note: 'Mode CRON : Heures']
 Note: 'Table des planification du batch' 
}

This informations are stock on sys.extended_properties where sys.extended_properties.name = MS_Description_Table

Other things : With the actual script we do not respect the order of the columns. Is it possible to keep the same order as the initial script ?
These information are very usefull particulary on our schema wich contains 742 tables and over 16 000 fields :-)

Thanks a lot

[huyleminh01]

Hi @MisterGeek ,

Which command did you use, sql2dbml or db2dbml?

From your description, I guess you utilized the db2dbml command, and the issue appeared.

With the actual script we do not respect the order of the columns. Is it possible to keep the same order as the initial script ?

Actually, we released a patched version that allows the ability to keep the tables and columns in ordinal order. You can check it here.

About the missing table description, it might be our bugs, so we will note this issue to our backlog and fix it. We will notify you if there are any updates.

Thanks.

[MisterGeek]

hi @huyleminh01
I'm not familiar with PR but I found the problem on the SQL Request.
I'll let you look at the correction

(For the order columns, it's looks great with the last version)
Thanks

[MisterGeek]

hi @huyleminh01 , if one of you could do the PR that would be great, as I could update our database model before the end of the year! thanks for the job !