Sql Azure : ALTER DATABASE & Pricing Implications
Posted by Stuart | Posted in SQL Azure | Posted on 12-10-2010
99
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.
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.
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. “

Purchase@Discount.Abana” rel=”nofollow”>……
Buywithout prescription…
Cheap@Abana.Online” rel=”nofollow”>..…
Buynow it…
pictures@of.abilify” rel=”nofollow”>..…
Buyno prescription…
Buy@Acai.Online” rel=”nofollow”>.…
Buywithout prescription…
Buy@Cheap.Acai” rel=”nofollow”>..…
Buydrugs without prescription…
acai@berry.detox.fort.worth.where.to.buy” rel=”nofollow”>..…
Buygeneric pills…
Purchase@Coral.Calcium.Online” rel=”nofollow”>..…
Buygeneric drugs…
Order@Cheap.Abana” rel=”nofollow”>.…
Buynow it…
coral@calcium.is.it.safe” rel=”nofollow”>..…
Buyit now…
Buy@Discount.Abilify” rel=”nofollow”>..…
Buygeneric meds…
Purchase@Coral.Calcium.Online” rel=”nofollow”>..…
Buygeneric meds…
Purchase@Discount.Coral.Calcium” rel=”nofollow”>……
Buygeneric pills…
Get@Coral.Calcium.Online” rel=”nofollow”>……
Buywithout prescription…
Buy@Acai.Online” rel=”nofollow”>.…
Buynow it…
Buy@Cheap.Acai” rel=”nofollow”>……
Buywithout prescription…
Buy@Discount.Acai” rel=”nofollow”>……
Buygeneric drugs…
Purchase@Acai.Online” rel=”nofollow”>……
Buynow it…
Purchase@Cheap.Acai” rel=”nofollow”>……
Buyit now…
Purchase@Cheap.Acai” rel=”nofollow”>……
Buygeneric drugs…
Purchase@Cheap.Acai” rel=”nofollow”>..…
Buywithout prescription…
Buy@Cheap.Energy.Boost” rel=”nofollow”>.…
Buygeneric drugs…
Purchase@Accutane.Online” rel=”nofollow”>.…
Buynow it…
Purchase@Cheap.Accutane” rel=”nofollow”>.…
Buynow it…
Order@Accutane.Without.Prescription” rel=”nofollow”>.…
Buygeneric drugs…
Cheap@Generic.Accutane.10mg.20mg” rel=”nofollow”>.…
Buyno prescription…
Get@Aciphex.Online” rel=”nofollow”>.…
Buygeneric pills…
Order@Generic.Aciphex” rel=”nofollow”>.…
Buygeneric drugs…
Order@Acomplia.Online” rel=”nofollow”>.…
Buygeneric meds…
Buy@Discount.Actoplus.Met” rel=”nofollow”>..…
Buygeneric pills zdg…
Buy@Discount.Actos” rel=”nofollow”>..…
Buygeneric meds qmo…
Order@Discount.Actos” rel=”nofollow”>..…
Buygeneric drugs krg…
Purchase@Cheap.Actos” rel=”nofollow”>..…
Buynow it vhx…
Order@Discount.Acular” rel=”nofollow”>.…
Buygeneric drugs zfk…
Cheap@Adalat.Online” rel=”nofollow”>..…
Buywithout prescription dyo…
Cheap@Abana.Online” rel=”nofollow”>..…
Buynow it tly…
Buy@Discount.Acai” rel=”nofollow”>.…
Buygeneric drugs axm…
Order@Discount.Acai” rel=”nofollow”>.…
Buygeneric drugs nih…
Get@Acai.Online” rel=”nofollow”>……
Buynow it zdg…
Order@Accupril.Online” rel=”nofollow”>..…
Buyno prescription tao…
Purchase@Accupril.Online” rel=”nofollow”>.…
Buywithout prescription yyn…
Buy@Accutane.Online” rel=”nofollow”>..…
Buyno prescription jui…
Order@Accutane.Without.Prescription” rel=”nofollow”>..…
Buyno prescription gdt…
Purchase@Accutane.Without.Prescription” rel=”nofollow”>.…
Buyit now ojb…
Purchase@Generic.Accutane.10mg.20mg” rel=”nofollow”>.…
Buygeneric drugs itj…
Purchase@Aciphex.Without.Prescription” rel=”nofollow”>.…
Buydrugs without prescription xab…
Buy@Generic.Aciphex.20mg” rel=”nofollow”>……
Buydrugs without prescription jlg…
Purchase@Discount.Acomplia” rel=”nofollow”>..…
Buynow it xmt…
Purchase@Cheap.Advair” rel=”nofollow”>.…
Buygeneric pills oir…
Get@Advair.Online” rel=”nofollow”>.…
Buygeneric drugs hwi…
Buy@Generic.Advair.Without.Prescription” rel=”nofollow”>..…
Buyno prescription jwi…
Purchase@Albenza.Online” rel=”nofollow”>……
Buydrugs without prescription ttp…
hair@growth.and.accutane” rel=”nofollow”>..…
Buygeneric drugs…
altace@cough.buy” rel=”nofollow”>..…
Buynow…
aciphex@muscle.pain” rel=”nofollow”>..…
Buygeneric pills…
actos@side.effects.edema” rel=”nofollow”>..…
Buygeneric drugs…
how@to.monitor.anafranil” rel=”nofollow”>.…
Buyno prescription…
antidepressant drugs for cats…
Buy_generic drugs…
alberta alcohol and drug abuse commission…
Buy_generic meds…
drug detection testing…
Buy_generic meds…
recipes for gastric bypass patients…
Buy_now…
citalopram length of use…
Buy_drugs without prescription…
best life diet…
Buy_no prescription…
weight gain stories feeders…
Buy_drugs without prescription…
accutane birth defects…
Buy_it now…
menstrual patterns in menopause…
Buy_no prescription…
dependent disorder anxiety…
Buy_generic pills…
green nerf ds lite armour…
Buy_generic pills…
bmi chart for kids…
Buy_generic drugs…
herbal flee collars for dogs…
Buy_generic pills…
buy cheap clomid…
Buy_it now…
statistics on pregnancy in high school…
Buy_generic meds…
what is valtrex used for…
Buy_generic drugs…
cures for fingernail fungi…
Buy_generic meds…
symptoms of chocolate allergy…
Buy_it now…
deadliest type of cancer…
Buy_generic pills…
bacterial staphylococcus aureus meningitis symptoms…
Buy_without prescription…
genie francis weight loss…
Buy_now…
st joseph aspirin coupon…
Buy_generic pills…
persistent nausea and stomach pain…
Buy_generic meds…
cordarone intravenous…
Buy_generic meds…
respiratory infection humidity dry antibiotics avelox…
Buy_generic pills…
find clomid cheap in us…
Buy_now…
hot spots or cancer…
Buy_without prescription…
south beach diet foods to avoid…
Buy_no prescription…
what causes constant itching…
Buy_generic pills…
washington university marfan losartan study…
Buy_drugs without prescription…
clinical trial ediary data…
Buy_now it…
juliet’s on the spot acne treatment…
Buy_drugs without prescription…
altitude and pregnancy…
Buy_it now…
glucophage powered by vbulletin version 2.2.1…
Buy_generic pills…
neurontin and mood lability…
Buy_generic meds…
menses while on birth control pills…
Buy_generic drugs…
medical nebulizer…
Buy_generic meds…
can iodine help thyroid function…
Buy_generic drugs…
breven medication for add…
Buy_generic drugs…
drug citalopram side effects…
Buy_generic drugs…
information about treatment for leg edema…
Buy_generic drugs…
air purifiers for allergies…
Buy_generic meds…
dogs to detect cancer…
Buy_generic drugs…