I develop locally on a laptop. If I want to develop remotely and forget to turn on VPN before I open SSMS and select a database, SQL Source Control has a fit because it can't find the repository. In fact, it becomes unusable until I've connected to the repository and unlink and relink the database in source control.

An offline mode would detect if the repository was unavailable and merely track changes until the repository is available again.