MDS migration - No data in the mdm view MasterDataServices
Hi ,
I migrated a model of Master Data Services
using
MDSModelDeploy.exe createpackage
-package "C:\temp\pck.pkg" -model "Product" -service MDS1 -includedata -version VERSION_1
and
MDSModelDeploy.exe deploynew -package "C:\temp\pck.pkg" -model "Product" -service "MDS1"
commands. The source sql server version is 2016 and destination is 2022. And all went well. When I open the mds webapp in the destination server I can see the Product model and all of its entities and data.
However if I go to the destination server MasterDataservices database views and open mdm.Product_SKU. The data is empty and I see only the column names. The staging table has data. The source servers mdm.Product_SKU has data. Please can someone tell if this is expected?
Why there is no data in the view at destination server and still the mds webapp populates the entity with all data?