Microsoft SQL Server Management ignores column

(2) Share

Report

Posted on by Jesús García

574

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

I have the same question (0)

All responses (4)

Answers (0)

Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Jesús García 574 on at

Like (0)

Report

Finance and Operations

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Jesús García 574 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

Microsoft SQL Server Management ignores column

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Microsoft SQL Server Management ignores column

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates