We would want to move shardlets from one database to another and would like to use split-merge tool. We were able to successfully deploy the split-merge tool using cloud service (classic) as mentioned here: https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-configure-deploy-split-and-merge
We are facing the following issue: [Exception] System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'dbo.InsertRequest'.
And the resolution you have provided in the same MSDN web page "In this case, check your configuration file, in particular the setting for WorkerRoleSynchronizationStorageAccountConnectionString. This error typically indicates that the worker role could not successfully initialize the metadata database on first use." does not work. I literally copy and paste the storage account connection string from Azure portal, so the connection string is not a problem.
Moreover, I see that the split-merge tool does not create any such stored procedure on start, nor can I find this stored procedure in the elastic scale library source code.
Can you please help?
At least can you please list the sequence of elastic scale client library method calls that we need to move a shardlet from one database to another.