Software Development for a Cloud Computing: IaaS, PaaS, SaaS, DaaS, AWS, Azure, Cloud Foundry, Heroku
 
Partition Data in SQL Azure

Partition Data in SQL Azure

This sample demonstrates how to partition your data in SQL Azure. It shows two ways: one is vertical partitioning while the other is horizontal partitioning. In this version of vertically partitioning for SQL Azure we are dividing all the tables in the schema across two or more SQL Azure databases. In this version of horizontal partitioning, every table exists in all the databases in the partition set.