Commit and validate IN MDS using store Procedure OR T-sql

Question

HI

Can any one  please  send t-sql or stored procedure script to commit and Validate data in MDS

Thanks!

Answer 1

See below.  I took this from here.

DECLARE @ModelName nVarchar(50) = 'Customer' 
DECLARE @Model_id int 
DECLARE @UserName nvarchar(50)= 'DOMAIN\user_name' 
DECLARE @User_ID int 
DECLARE @Version_ID int 
SET @User_ID =  (SELECT ID  
                 FROM  mdm.tblUser u 
                 WHERE u.UserName = @UserName) 
SET @Model_ID = (SELECT Model_ID 
                 FROM mdm.viw_SYSTEM_SCHEMA_VERSION 
                 WHERE Model_Name = @ModelName) 
SET @Version_ID = (SELECT MAX(ID) 
                   FROM mdm.viw_SYSTEM_SCHEMA_VERSION 
                   WHERE Model_ID = @Model_ID)
EXECUTE mdm.udpValidateModel @User_ID, @Model_ID, @Version_ID, 1