What happens if the location of the database changes after creating the automation?

If the location of your database changes, 2sync may ask you to add a connection to it again if you lack permissions in the new location. In that case, you will need to ask for permission from the owner to reconnect your database.