“Commit all must be called when a managed buffer has focus” in Microsoft SQL Server Data Tools

Written on April 24, 2013

When using the Microsoft SQL Server Data Tools in Visual Studio 2012 and trying to update a SQL Azure database (having modified the column definitions) by hitting the "Update" Button,

Hitting the Update Button

I sometimes receive an error:

Sometimes produces an error

I did not find a solution to get fully rid of it, but the workaround is to click into the T-SQL-Window below the Designer and hit the "Update" Button again:

Which can be resolved by clicking into the T-SQL Window

After that, the database update works as expected:

Problem solved!