StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSQL Server hosting only offers 1GB databases. How do I split my data up?
text
Body
copied!<p>Using ASP.NET and Windows Stack.</p> <p><strong>Purpose:</strong> Ive got a website that takes in over 1GB of data about every 6 months. So as you can tell my database can become huge.</p> <p><strong>Problem:</strong> Most hosting providers only offer Databases in 1GB increments. This means that every time I go over another 1GB, I will need to create another Database. I have absolutely no experience in this type of setup and Im looking for some advice on what to do?</p> <p><strong>Wondering:</strong></p> <ol> <li>Do I move the membership stuff over to a separate database? This still won't solve much because of the size of the other data I have.</li> <li>Do I archive data into another database? If I do, how to I allow users to access it?</li> <li>If I split the data between two databases, do I name the tables the same?</li> <li>I query all my data with LINQ. So establishing a few different connections wouldn't be a horrible thing.</li> <li>Is there a hosting provider that anyone knows of that can scale their databases?</li> </ol> <p>I just want to know what to do? How can I solve this dilemma? I don't have the advertising dollars coming in to spend more than $50 a month so far... </p> <p>While <a href="http://www.ultimahosts.net/windows/vps/" rel="nofollow noreferrer">http://www.ultimahosts.net/windows/vps/</a> seems to offer the best solution for the best price, they still split the databases up. So where do I go from here?</p> <p>Again, I am a total amateur to multiple databases. Ive only used one at a time..</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload