Field size in dbml file

[akuiteo-dbdocs]

Before using the automatic generation of the DBML file for SQL server, I had queries allowing me to generate my file in DBML format.
In these scripts, I retrieved the field type and size, which was very useful when viewing fields in dbdocs.

Example :

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']
}

With “dbdocs db2dbml mssql” I no longer have this information, which is a big loss compared with what I used to produce. Would it be possible to have this data?

Table "dbo"."B_BATCH_PLANIF" {
  "BBPL_ANNEE" numeric
  "BBPL_AV_ANNEE" nvarchar [note: 'Mode CRON : Annee(s)']
  "BBPL_AV_HEURE" nvarchar [note: 'Mode CRON : Heures']
}

[huyleminh01]

Hi @akuiteo-dbdocs,

Thank you for reporting the bug to us.

It maybe a bug related to db2dbml command, we will investigate this issue and get back to you later.

Thanks.

[huyleminh01]

Hi @akuiteo-dbdocs ,

We checked and confirmed that our connector does not fetch the field size (numeric scale, numeric precision, and string length).

So we have released a fixed version in @dbml/[email protected]. We will update it to dbdocs cli later. But you can try dbml cli to test our new fix first.

Thanks.

[huyleminh01]

Hi @akuiteo-dbdocs ,

There is good news: we've just released dbdocs cli v0.13.1 contains this fix 🥳 . Please try it out

[akuiteo-dbdocs]

It's work like a charm ! Thanks a lot