question

zanzand avatar image
0 Votes"
zanzand asked SeeyaXi-msft commented

Issues capturing MDS schema in SSDT project

Using MDS on SQLServer 2019/Windows 2019. Database version 15.0.5.1. VS2019 with SSDT.

The presence of a fully qualified view name (master.sys.syslanguages) in one of the MDS stored procedures seems to cause problems when trying to compare the schema and load it into a local project:

udpTransactionSave, line 131:

 SELECT @Dateformat = CAST([dateformat] AS NVARCHAR(6)) FROM master.sys.syslanguages where langid = @@langid

Adding a database reference to the master database won't work using Add Database Reference\System Database. As a workaround, I used Add Database Reference\Data-tier Application (.dacpac), pointing to the physical location of the master.dacpac file (not using $(DacPacRootPath) variable), with the option "Same database". This leaves this particular unresolved reference as a warning, but at least there are not dozens of errors that prevent the project from building correctly.

I don't know of any way to submit this as an issue to Microsoft.
This might help others; there was fairly little about this issue online, except the standard "add master database reference", which won't help in this case.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @zanzand,

Welcome to Microsoft Q&A!
For the convenience of other members, I've put this related official document here: https://docs.microsoft.com/en-us/sql/master-data-services/install-windows/create-a-master-data-services-database?view=sql-server-ver16
Further more, here is a feedback site: https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0

Best regards,
Seeya

0 Votes 0 ·

1 Answer

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

The place ti submit bugs and suggestions - short of opening a support case - is https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.