So you need to migrate from SQL Azure Web to Business : Migrate your say? Wrong.
You can just look up SQL Managment Studio 2008 (R2) and Add the following
[code]
ALTER DATABASE database_name
{
MODIFY NAME = new_database_name
|MODIFY (<edition_options> [, ..n])
}
<edition_options> ::=
{
(MAXSIZE = {1 | 5 | 10 | 20 | 30 | 40 | 50} GB)
|(EDITION = {'web' | 'business'})
}
[;]
[/code]
Assuming you are connected to the Master Db then it you could, for example upgrade from a 5GB Web to 10GB Business Azure DB
[code]
ALTER DATABASE [DB_NAME] Modify (EDITION = 'business', MAXSIZE = 10 GB)
[/code]
Another good article on this is http://blogs.msdn.com/b/sqlazure/archive/2010/06/16/10026036.aspx
More can be found out on MSDN @ http://msdn.microsoft.com/en-us/library/ff394109.aspx
But how does this affect your pricing? Well you need to read the following document.
http://blogs.msdn.com/b/cbiyikoglu/archive/2010/06/10/pricing-for-the-new-large-sql-azure-databases-explained.aspx
Except from link below
“Lets look at a few examples; Assume we have a a web edition database that has a MAXSIZE=5GB. If the database size is 800MB, the daily charge for the database will be at the 1GB rate for web edition. if the next day, the database size grows to 3GBs, the daily charge will be based on the next billing increment for web edition which is 5GB for that day. If the next day, after some data deletion, the size drops back to 900MB, the daily charge will be based on 1GB back again.
The same example applies to a business edition edition database. Assume we have a business edition database with MAXSIZE=50GB. If the total database size is 8GB, the daily charge for the database will be at the 10GB rate. If the next day, the database size grows to 25GB, the daily charge will be based on the next billing increment for the business edition which is 30GB and so on.
Lets look at a few examples; Assume we have a a web edition database that has a MAXSIZE=5GB. If the database size is 800MB, the daily charge for the database will be at the 1GB rate for web edition. if the next day, the database size grows to 3GBs, the daily charge will be based on the next billing increment for web edition which is 5GB for that day. If the next day, after some data deletion, the size drops back to 900MB, the daily charge will be based on 1GB back again.
The same example applies to a business edition edition database. Assume we have a business edition database with MAXSIZE=50GB. If the total database size is 8GB, the daily charge for the database will be at the 10GB rate. If the next day, the database size grows to 25GB, the daily charge will be based on the next billing increment for the business edition which is 30GB and so on. “