Home » Microsoft TechnologiesRSS

Steps to do database sharding in sql Azure

Hi,

        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.

  http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/936758d3-e84d-4e46-add3-f4ee3faad524

 

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.

http://blogs.msdn.com/b/sqlazure/archive/2010/06/24/10029719.aspx

 

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.

http://enzosqlshard.codeplex.com

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

 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter