Posted By HansZ on 09 Aug 2019 01:03 PM
I believe that in the script all you would need to add is a USE Database directive referening the name of your database name maintained in the web.config file.
I haven't tried that specifically recently, but in my case, we're often using a different data source altogether (e.g., other server, other DB server, etc.) and it requires an additional data connection string instead of USE.
Oh, and to address an earlier comment... I wouldn't ever suggest putting any connection string details in the AppSettings. You should use the connectionStrings section in the web.config instead. :)