Home » AzureRSS

Upgrade SQL Azure database schema while in production

The question that I currently have: Is it possible to upgrade schemas [ Add tables/fields/indexes…] in SQLAzure while the database is in use and what are the risks in doing this?

Some of our datatables have quite a lot of records (100million and up)


1 Answer Found


Answer 1

Hi Rudi,

I think SQL Azure and SQL Server should have the same behavior. For SQL Server, when modifying a table use the ALTER TABLE statement, a schema  modify lock is acquired on the table to block other connections.

For more information, please see the following document (the Locks and ALTER TABLE section):



<< Previous      Next >>

Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter