Microsoft SQL Server Management ignores column

(2) Share

Report

Posted on by Jesús García

401

Hi all! Something strange is happening to me regarding an export from D365 to an external database. From D365, I make a data export to that database and, if it is the first time I export it, it is automatically created by a sqlCommand. So far so good. In the external database related to UAT2 it exports correctly, however, in another database related to UAT when creating the table, it ignores a field and does not create that column. I have been checking if it could be that I have deleted it from the entity but everything is correct. Is there any property in MSSM that allows to ignore the creation of a column? As a curiosity, all the rows of this table, in that field contain the value NULL.
Translated with DeepL.com (free version)

Categories:

Dynamics 365 Finance

All responses (4)

Answers (0)

Jesús García 401 on at

Like (0)

Report

Microsoft SQL Server Management ignores column

Correct, this field contains the null value in all rows, and it exports all this value to external DB in UAT2 creating this column, but in UAT it ignores this column
Martin Dráb 231,872 Most Valuable Professional on at

Like (0)

Report

Microsoft SQL Server Management ignores column

Are you saying that the field doesn't get created at all in UAT's BYOD and it gets created but never populated in UAT2's BYOD?

Moved from Integration, Dataverse, and general topics forum.
Jesús García 401 on at

Like (0)

Report

Microsoft SQL Server Management ignores column

Finance and Operations
Martin Dráb 231,872 Most Valuable Professional on at

Like (0)

Report

Microsoft SQL Server Management ignores column

Which D365 product are you using? The D365 brand covers quite a few things, such as Finance and Operations, Business Central or Customer Engagement.