Upgrading SQL Azure database size

I'm currently in the middle of developing an application loosely similar to StackOverflow (question / answer based)开发者_如何学JAVA

Initially, I was using AWS (simple db and s3) for storage, however that posed several problems, and i've opted to go with SQL - With a view to eventually hosting on SQL Azure.

I was just wondering, if i opted for the 1gb database initially, could I increase the size to the 5gb / 10gb databases later on? Or would I have to create a separate new database of this size, and port my data over?

---

See my answer on this other SO question. In a nutshell, you modify db size with T-SQL, such as:

ALTER DATABASE MyDatabase MODIFY (EDITION='WEB', MAXSIZE=5GB)

---

You can also change the size of the database through the Azure SQL portal. Simply choose the database and go to the scale tab and select the size you want.

Tada

---

Just wanted to expand on Dave's answer since it is very easy in the management tool:

---

If you're working with SQL Azure Pools than you can execute the follow from the master

ALTER DATABASE database_name
MODIFY (MAXSIZE = x GB)

The key difference being the omission of the 'Edition` parameter. There are certain size restrictions though, which can be found here.