Start small and grow larger with SQL Server 2012 - code and price wise
I am developing my new web / mobile app using ASP.NET 4.5 and SQL Server 2012. I expect my DB to be very large, and reach terabytes of data. I know that in order to pick up with the high write and read of my application, as well as the data capacity, I will need to use clustering. What I wanted to know if there is a solution that will enable me to start with one server / one database and when I need more capacity room, I can implement it without making changed to my code.

I prefer working with SQL Server 2012 and not using NoSQL solutions. What are my options. Are there any DBaaS solution that allows you to query against one database, but behind the scenes implement a clustered environment that can scale to terabytes of data storage.

Choosing Amazon RDS for SQL Server 2012 is a good way to start, but what happens when I need more room, larger than 1TB. Furthermore, it's not recommended to use large databases. SQL Azure and federation is one option, but it seems to expensive for storing large databases and you need to make changes to your code. Maybe there is some kind of middleware that can take care of that?

What I need:

 1. SQL Server 2012 deployment, start small and be able to grow when database capacity grows
 2. Being able to easily backup and restore data
 3. Start with a regular SQL Server 2012 installation and go to a more advanced architecture without code changes to my application
 4. Considering a DBaaS solution
 5. Need the solution to support triggers



Thanks
Start small and grow larger with SQL Server 2012 - code and price wise
===

I am developing my new web / mobile app using ASP.NET 4.5 and SQL Server 2012. I expect my DB to be very large, and reach terabytes of data. I know that in order to pick up with the high write and read of my application, as well as the data capacity, I will need to use clustering. What I wanted to know if there is a solution that will enable me to start with one server / one database and when I need more capacity room, I can implement it without making changed to my code.

I prefer working with SQL Server 2012 and not using NoSQL solutions. What are my options. Are there any DBaaS solution that allows you to query against one database, but behind the scenes implement a clustered environment that can scale to terabytes of data storage.

Choosing Amazon RDS for SQL Server 2012 is a good way to start, but what happens when I need more room, larger than 1TB. Furthermore, it's not recommended to use large databases. SQL Azure and federation is one option, but it seems to expensive for storing large databases and you need to make changes to your code. Maybe there is some kind of middleware that can take care of that?

What I need:

 1. SQL Server 2012 deployment, start small and be able to grow when database capacity grows
 2. Being able to easily backup and restore data
 3. Start with a regular SQL Server 2012 installation and go to a more advanced architecture without code changes to my application
 4. Considering a DBaaS solution
 5. Need the solution to support triggers



Thanks