Scrip sql change Provide when clone database from cloud to on-premise Dynamic 365 Retail

Scrip sql change provide when clone database from cloud to on-premise Dynamic 365 Retail

Song Nghia - Technical Consultant

Update dbo.USERINFO set Enable = '1' 

Update dbo.RetailTransactionServiceProfile set AzureResource = 'https://usnconeboxax1aos.cloud.onebox.dynamics.com' 

Update dbo.RetailTransactionServiceProfile set ServiceHostUrl = 'https://usnconeboxax1aossoap.cloud.onebox.dynamics.com' 

Update dbo.RETAILCONNDATABASEPROFILE set ConnectionString = 'AQAAAHNm4l3JT6ikAPoAN//zuzANlILUc2biXclPqKQA+gA3//O7MA2UgtRPAwRDTnplG8+rzS9omxRxmMRG72nKnkzG8RyAzutFnbPmItYRZ3TJ+phMNjDIYIXzV/b/g0sZSExFdZgzDKWya6vZimKx8YCmMCdtl3b8h6VCVnFrRe1f62OKx6kf5DGG9g3JFWv/jfsJRldrgzZv0Wx/+a328WTxKHR/wgNtwTVyzWcc+krMwxLbAnSAtKBYQLD3ewn+MX76SONOmFjp/+sh9Ml5ZcLNHgOQen824hy261hutcBt5XwPYHoUVGw5dVMdurtX9Zp7mrKn0+Ep0W8UuDTbSkaNbm0UaNOVLLMVEIxgy8tIQinx0pz54n12zd0YPo/7NfQUY2Ud2OMNF7kpGZkDSVjUHEsYJRNkHn5g13VSdwxjJOfyy8Ad1y0Czxz4esCGLQWIgboPAXu5KNPYnfnILYVwmZZGLFy3o0TL75zvb6bAREpgSJi38Syjl1pspQm+8Vocs/vNnHpA8eM/f/o63Lx/KIzzwfFi40rVGEPyqgsnvCyMlqXxhnWoeuPEVVscuhEfcE7BCi/Sui2qaExzvNegUHb+G4kEbmBD8EjdHQl7w1a97tYiA+8ZEqsnaUIyrziSwWIUDQsUf7gAwT4bOdke7i8XrK38YRrVrq04U9JZYcvum4DOyEJ6sX7DzSzxUYYS5KBky61n064pO9HJu3idG1ym6Vgi1o/HepDb0TzIjTxJGYHclNVcZz5ttbQCeOOkTW+vnQr6maKzqK44cDdbUgs4Ik2vKagtDo7YToaWv/IcYVI/qSXpbCKLWjd5jsocMgP1+c/AJBouemSOyrvZfKvfoRWk56XAV1ELj0xBxedITv+5P/qWMh0iKeBDTJx1mtBYCaojQ+UPig9vFBUyQB3sE6e6pNGEeuIcv6avPCxnn2SK879vRCwsH6yRSnNpIqaxTQDe6JSKloAEgrZLgYlCOsINlHQi8wkf93BwxWLIXTWYqAmG0Mm1/y04Ydw+0sq+jeUQ' 

where Name = 'Default' 

Update dbo.RETAILCHANNELPROFILEPROPERTY set Value = 'https://usnconeboxax1ret.cloud.onebox.dynamics.com/Commerce' 

where ChannelProfile = '5637144576' and key_ = '1'  

Update dbo.RETAILCHANNELPROFILEPROPERTY set Value = 'https://usnconeboxax1pos.cloud.onebox.dynamics.com' 

where ChannelProfile = '5637144576' and key_ = '7' 

Update dbo.RETAILCHANNELPROFILEPROPERTY set Value = 'https://usnconeboxax1ret.cloud.onebox.dynamics.com/MediaServer/' 

where ChannelProfile = '5637144576' and key_ = '2' 

EXEC sp_addrolemember 'DataSyncUsersRole','axretaildatasyncuser'; 

EXEC sp_addrolemember 'db_owner','axretaildatasyncuser'; 

delete crt.DOWNLOADSESSIONDATAFILEHISTORY 

delete  ax.retailassortmentlookup 

Solution:  from my Technical Architect  in company.