BuzzBID Multi-User Database Update Guide

Request Version File: To receive the newest version of BuzzBID for your update, please click here:👉
Request Newest Version File

Schedule Assisted Update: If you change your mind and want to schedule an assisted update via a live Zoom session, please click here: 👉 Schedule Assisted Update Session

Scheduling: BuzzBID recommends scheduling updates in advance with your team to guarantee no active, urgent bids are in progress.
Timing: We highly recommend performing this update before or after your normal business hours.
Buffer Window: We suggest scheduling a minimum of 1 hour of anticipated downtime to account for validation and any unexpected environment delays.
Database Owner: Plan for 15 to 30 minutes to complete the initial client install and SQL database schema upgrade, depending on database size.
Standard Users: Plan for 5 minutes per user to download and install the client software update.
Final Validation: We recommend having at least one standard user complete their update early to perform a final login verification before opening access to the rest of the team.

Action: Verify existing backups or take a fresh backup of your BuzzBID SQL database(s).
Why: This acts as a safety net to protect your data.

Action: Ensure every single user has completely logged out.
Query: Run this script in SQL Server Management Studio to check active users:sql
```
SELECT * FROM ConnectedUser; 
```
Force Disconnect: If a user is unavailable to close BuzzBID, remove them manually:sql
```
DELETE FROM ConnectedUser WHERE UserEmail='xxxx@xxxxx'; 
```

Use code with extreme caution.

Action: The Database Owner must update their BuzzBID client software first.
Process: Launching the updated client automatically detects your admin permissions.
Result: The system upgrades the database schema to the latest version.

Action: Log in to inspect your current Projects for a quick check.
Multi-DB: Select any additional BuzzBID databases to trigger their schema updates.
Final Step: Once confirmed successful, all other users can safely update their clients and log in.

Schema Update Fails: If the client displays an error during the schema upgrade, do not allow other users to update. Restore your step 1 backup immediately and contact support.
Locked Connections: If the ConnectedUser table is clear but users still cannot connect, restart the SQL Server browser service to clear cached sessions.
Permission Errors: Ensure the user running the first update has db_owner role permissions assigned within SQL Server.

Our support team is ready to help you through the update process or jump onto a live Zoom session:

The BuzzBID team is eager to assist you through the update process via a live Zoom meeting. Some customers have confidence in their ability to update without assistance and only want BuzzBID to provide them with the new version file. This guide is for self-service, unassisted updates.