Setting Shards - ListSharding command not working

Question

Hello,
I have executed the below command as indicated in the documentation for list sharding but I am getting command not recognized error:

$ShardMap = New-ListShardMap -KeyType $([int]) -ListShardMapName 'ListShardMap' -ShardMapManager $ShardMapManager

https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-convert-to-use-elastic-tools

If I execute the Range Sharding command it works. Here is the exact error I am getting:

New-ListShardMap : The term 'New-ListShardMap' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name,
or if a path was included, verify that the path is correct and try again.
At line:1 char:13

• $ShardMap = New-ListShardMap -KeyType $([int]) -ListShardMapName 'Lis ...
• ~~~~~~~~~~~~~~~~
• CategoryInfo : ObjectNotFound: (New-ListShardMap:String) [], CommandNotFoundException
• FullyQualifiedErrorId : CommandNotFoundException

Answer 1

@Raja1203 Welcome to Microsoft Q&A and thank you for your interest in Azure SQL Database.

New-ListShardMap is function defined in Azure SQL Database - Elastic Database tools scripts. This is a separate download as mentioned in the Overview section of the documentation.

Please try and let us know if you face any further issues.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.