Change repository location on multiple pre-existing packages
I got transferred to a new site, so I'm taking over for another tech. I started doing Pull deployments at my previous site, and wish to do the same here. There are hundreds of packages the previous tech created that reference a static local file path - C:\PDQ_Deploy\Local_Packages.
As I've been using packages, I've been updating the path to say "$(Repository)....". However, there are still hundreds, and I'd like to change them all in one command, if possible.
I can access the SQLite console, but my database-fu is not as good as I wish it was, and I'm sure I'd screw something up with the wrong command. I know I need to edit at least the PackageSteps table, but I'm not exactly sure how.