From the error description, it indicates that:

Your test database uses case-insensitive collation, where your prod database uses case-sensitive collation.

The error indicates that SQL cannot find the specified database.

Please verify that the database name used in the script EXACTLY matches the actual database name, including case.

If it doesn't already, have the script print out the value of the database name as the script is executing.