Like Andy said, when you update the files and visit the admin of your site, then it will upgrade that database.
That plugin may or may not help you out depending on what exactly is broken on your site. In theory that plugin and BuddyPress 1.2-beta should enable your current BuddyPress 1.1-theme and most plugins to work as-is.
