I'm in the process of upgrading from Sitecore 8.2 to Sitecore 10x. With Sitecore 8.2 I was easily able to switch between databases simply by swapping out the connectionstrings, preferably by web.config transformation during deploys.
How would I switch databases in Sitecore 10x? A simple swap does not work and gives me an error message which states
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
To me that means that there are other config files that need to be updated when I build or deploy other than just the connectionstrings.config. I have Googled and manually (windiff) searched for config and even xml files that might need to be updated but I have not discovered what else I need to do.
Question
Does anyone know what all config files I need to update when switching between databases and database locations for development and production environments? Using the exact same names in development and in production will not be an option because of my company's business rules.
