As indicated in the previous post, a simple upgrade that required no Database work has taken up time across multiple days. I should really point out that DAY 1, DAY 2, etc is really a matter of a couple of hours per day, if that. And as promised…
DAY 4
So, after a little bit of research, it turns out that a batch file interprets a comma [,] as a delimiter when passing it in. So, when we were passing the connection string to the batch file, we needed to include the port number. In this case let’s say DBSERVER,12345. The batch file was splitting that and sending 12345 as the second parameter. Easy enough fix, let’s wrap that in quotes [“]! Well, that worked, sort of, but not really. When you use string comparisons in your batch file that looks like
@IF "%1" == "/?" GOTO PrintHelp