I have a list of files generated from SSMS in XP like this:
dbo.mysproc1.StoredProcedure.sql dbo.mysproc2.StoredProcedure.sql dbo.mySproc3.StoredProcedure.sql ... you get the drift
I want to rename them to:
proc.dbo.mysproc1.sql proc.dbo.mysproc2.sql proc.dbo.mySproc3.sql ... you get the drift
I'm open to powershell, plain old batch, or whatever. If you can do it with a regex that would be fascinating, but whatever works there too. I want the ends, not the means, yeah? Just not sure what command to use. I do not, however, want to download a tool to do this. Native XP SP3 please.
This is a one-off job, not something to be scripted, if that matters. But I may repeat it in the future, so scriptable is not a bad thing.