Which SQL module version of PowerShell has -autorelocate cmdlet available

Question

I am trying to build a migration script and use the -autorelocate cmdlet to perform restore in the destination sql server.
the -autorelocate cmdlet is missing from the list of cmdlets that appear through intellisense in the restore-sqldatabase syntax.
Would like some assistance on why this cmd is missing and how to get it back through a specific SQL module version.

Answer 1

Hi @Aravind PowerShell ,

From the SQL Server cmdlet do not have the cmdlet you said
https://www.powershellgallery.com/packages/SqlServer/22.0.30-preview

If you want to relocate, you can see this cmdlet: New-RestoreLocation

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

The current version of the SQLServer module is 21.1.18256. See here: 21.1.18256

FYI, the cmdlet is Restore-SqlDatabase. That cmdlet has a parameter named "-AutoRelocateFile".

Answer 3

Hi @Aravind PowerShell
This tag (openspecs-sqlserver) is dedicated to supporting issues related to open specifications. You can find open specifications here https://learn.microsoft.com/en-us/openspecs/
I have removed openspecs-sqlserver tag and have added sql-server-general tag, where you have a better chance of getting an answer.

Regards,
Obaid Farooqi - MSFT