I am upgrading to a new version of nopCommerce. I've run the database upgrade scripts locally and now I need to get those changes to the production database. Can I (or should I) run the upgrade scripts on the production database? Or is there some other method of updating the production database?
You might want to first backup your SQL database through the control panel's backup tools first before running the script. Then run the script to see if it works. If it breaks the SQL database. You can always revert back to the backup you created. Read our knowledge base article on how to backup your SQL database here: https://support.everleap.com/kb/a1231/getting-started-with-ms-sql-server-databases.aspx