When dealing with commerce we see that it stores connection strings in the databases, for example in the MSCS_Admin the table resourceprops stores all sorts of connection information. Now say you want to restore all commerce databases from server A into server B and just update connection strings, what are the places one need to update? What are all the databases impacted and which ones need to be updated? Do I need to manually build SQL scripts for that to update each row with the new connection or is there an easier way to do so?
Update: This is Sitecore 8.2 update 3 with Commerce 8.2.1(initial release)