Feature request: find and replace in SQL restore path names

[bobber85]

We often perform data refresh restores of production databases to dev/sandbox systems. The databases have multiple files, in multiple folders (that is the way the application and original DBAs defined it for performance). When we do the SQL restore to another server, we have to rename all the folders and files to match up with the system that is the restore target. Example: Source: G:\ProdDB1\ProdDB1.mdf Target: G:\DevDB1\DevDB1.mdf The DBs we restore most often have an mdf, 5 ndf and an ldf that all need to be renamed similarly. It would improve our workflow if we could search the target paths for "Prod" and replace with "Dev" (using the example), instead of having to change 2 items on each of the 7 lines. Thank you!

[veremin]

The process of restoring and renaming SQL files can be automated via PowerShell. Does this solve your issue? Thanks!