Home » Microsoft Technologies

Steps to do database sharding in sql Azure


        I want to implement database partition(sharding)  in sql Azure and i got below link in forum ,so my query is it completely manual process to do partition in database or is there any built in feature which can help to Scaling up and scaling down in sql azure.



Please help me if any one have idea on same.


Thanks in advance..



4 Answers Found


Answer 1

You should post this on the SQL Azure forum.


Answer 2

You could probably dream up a scheme of sharding  and use SSIS to make it happen.

Answer 3

The short answer is no, its is up to you as a developer to make sharding  work.

MS employees have posted an excellent example how this can be done in sql  Azure.



Have a look at it and see if it gives you some understanding and inspiration how it can be achived.


- Raoul


Answer 4

There is a sharding  library on codeplex that does just what you are looking for.


This sharding library is continually updated so if you have feedback please post your comments.




        I want to implement database partition(sharding)  in sql Azure and i got below link in forum ,so my query is it completely manual process to do partition in database or is there any built in feature which can help to Scaling up and scaling down in sql azure.



Please help me if any one have idea on same.


Thanks in advance..



Using Backup and restore, what are the necessary step by step process to Move/migrate a SQL Server 2005 database on 'Server A' to SQL Server 2008 on 'Server B'

Pre-migration tasks, Migrations tasks, and post migration task.

How to migrate SQL Azure database to local database?

Hi all,

I need to migrate my data from sql server to sql azure and from a sql azure to another sql azure. in both cases, data must be migrated directly without being exported to files.

bcp or bulkcopy can migrate data but data will be exported to files before copied to sql azure database. 

Are there any ways to do those tasks?

Can SSIS do so? How does SSIS actually do? Queries all data from source database to memory then copy it to destination database?


Hi folks,

I am new to SQL Azure.

We would like to deploy our database with data (now in SQL Server 2005) to SQL Azure.

As I understand from the link below, I can use the tool SQL Azure Migration Wizard.


But it also mentioned about "run the SQL Server 2008 Upgrade Advisor". Does this mean I can only import the dabase if my SQL Server 2005 DB passed the 2008 Upgrade Advisor check?


I don't have an Azure account for test now. So I can only count on your answers for this question for now.

Thank you,


i'm new to this WSSF, anybody can provide a sample application which interacts with database table plz.

Thanks in advance,


Database Mail relies on SQL Server Agent so is not supported in SQL Azure.
If you are using Database Mail on an existing application and you planned to move it on Azure, you need to change it or make the Database Mail system stored procedures work on SQL Azure.

I wrote a blog post on this so, if you hare looking for a solution, I hope it can be helpful to move your solution to the cloud without changing it.




I am trying to connect Oracle 10g Release 2 database base.
I am running with BizTalk 2010 (32bit) and VS 2010 and I installed BizTalk Adapter Pack which comes with BizTalk 2010 Setup.

my OS is windows 2008 32bit.

I installed with Biztalk 2010 CD, Do I still required to install WCF LOB Adapter SDK SP2  ?

Which version of Oracle Client should I install to connect Oracle Database ? 

Can some one send me the correct link to download the Oracle Client ?  which should not give any Oracle DataAccess.dll  problem.

Thanks in advance.



I am new in SQl Azure.

I have created SQl Azure Database in Windows Azure Control Panel and the Test connection was Sucess.

And i tried connect it from Sqlserver 2008 Enterprise Edition Client (sp1) Management studio. I coud see the Master and [Test Database](My database) .

If i select [Test Database] i am getting the "Database is not Accessible" error.

Can any one help me



Liyasker Samraj K
I read in the FAQ that any number of databases can be created in SQL Azure since PDC 09. So, I log into SQL Azure and create 5 new databases with max size of 1 GB each and then I read about the pricing of SQL Azure, it says 1GB = 9.99 per month.
Here are two ways that I interpreted that statement, please tell me which (or neither) is correct.
Case One: I would end up paying  5 * 9.99 for my 5 databases + 9.99 (1GB for master)
Case Two: I pay 9.99 per month as long as all the Databases that I create are using less than 1GB collectively.

Case Two makes more sense but I need a confirmation and was unable to get answers by searching.

Thanks for the info.


It is a delight to announce the availability of the AdventureWorks Community Sample Databases for SQL Azure.  You can download the scripts and data files from CodePlexTo install the databases on your SQL Azure server just follow the directions on the release page at CodePlex or in the ReadMe.htm file which is included in the zip file.

The scripts and data files in the zip file can be used to create the data warehouse (DW) and light (LT) sample databases in a SQL Azure server without SQL Server or Visual Studio being installed on the machine performing the installation.  Currently the AdventureWorks OLTP database is not supported for SQL Azure and is not included in the zip file.


Hi Support,

I have completed my SQL Database Migration, etc etc. Our users will be uploading files of which will insert data into our SQL Azure Database. In the past there has been problems with this, and I had to restore the SQL Database (2008) to a point and date in time.

Is it possible to do this with Azure? If so how?

Thanks for your help,


Kind Regards



www.sms-roster.com, www.sassytoll.com

I'm currently in the middle of developing an application loosely similar to this forum (question / answer based)

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?

Hi Support,

Is it possible to create create the Application Services Database for SQL Azure. I would like to use my existing Asp Membership, Profile, Roles etc tables and move the data to Azure? When I run the Aspnet_regsql.exe command, I can connect just fine. But I get an Error: 

 "An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 40508 and the SqlException message is: USE statement is not supported to switch between databases. Use a new connection to connect to a different Database"

I have allowed Microsoft Services in the Firewall Setting and Added a rule only for my IP address.

What can I do?

Kind Regards

John Galvin
www.sms-roster.com. Microsoft Bizspark Company




Is there any tool available for Migrating Oracle Database Objects to SQL Azure?

I got SSMA Oracle,which migrates data base objects to SQL Server 2005/2008..but I have not found any such thing for SQL Azure. Please let me know is there any kinda tool available for this or I need to migrate Oracle database Objects to SQL Server R2 first then to SQL Azure.


Thanks & Regards,




I have on wrapper job which in first two steps call two other jobs. Now in the third step I want to check the whether the jobs called in the first two step are completed successfully or not. If the both the jobs are successful then mark the Wrppar job as s success else mark the Wrapper job as failure.

In the current situation I am using sp_startjob to start two jobs in the 1st and 2nd step of the Wrapper job but when the job goes to the third step the 2 jobs are which are called are not completed so the third step gets the status as "executing" and as it is not success it marks the wrapper job as failure and job ends.

Now, I want the Wrapper job to end only when the two called jobs are complete and we can also check the final status of both the job to decide the fate of the wrapper job.

Thanks in Advance




I have Visual Studio database projects, and I would like to deploy them to SQL Azure.
What are the best practices to for SQL Azure deployment using Visual Studio database projects?

Right now, I am using a manual and lengthy process.
First I deploy it to local server, then generate scripts that I run against SQL Azure.

Can I use vsdbcmd.exe  to deploy to Azure?



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)


Qns 1) I am using SQL Azure Migration Wizard v3.3.5 wizard to generate scripts from SQL Azure database. I

successfully connect to sql azure database as source but when i am on last step then this application throws an

following window error

SQLAzureMW has stopped working

Windows can check online for a solution to the problem.

1. Check online for a solution and close the program
2. Close the program.
3. Debug the program.

I heard about database size limits in SQL Azure. I was considering porting my database which is currently small but I'm expecting it grow in size considerably. What happens if my DB gets too large? Would I have to go back to a dedicated server which doesn't really make sense?

<< Previous      Next >>

Microsoft   |   Windows   |   Visual Studio   |   Sharepoint   |   Azure