Converting from SQL - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Converting from SQL

Author

Topic

Keysle
Starting Member

15 Posts

Posted - 2010-10-08 : 15:29:45

Is it easy to switch over from SQL to a more powerful database type after my SQL DB has reached it's limits?

http://Keysle.com
/* I am going to be on here a lot until I get my project done */

X002548
Not Just a Number

15586 Posts

Posted - 2010-10-08 : 15:32:31

ok...who's got a rag....I need to wipe all this bee....ummmm, coffee (yeah, coffee, that's it) off my monitor

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-08 : 15:32:33

SQL Server is very powerful. There is no reason to convert to another platform.

Please define what you mean by "SQL" though. Are you referring to SQL Server, MySql, Oracle, ...?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Keysle
Starting Member

15 Posts

Posted - 2010-10-08 : 15:49:15

MySQL.

If it's so powerful, then why doesn't Facebook and Google use it?
Is it just because they want to do "their own thing"

I can assure you that google has over a quadrillion rows in their DB
I know that It's easy to say that I won't have as much as data as they will, but I will eventually have 1/100 of what they have. And I can safely say that is even more than facebook.

X002548
Not Just a Number

15586 Posts

Posted - 2010-10-08 : 15:59:27

ahhh...mySQL database has reached it's limits...yes...I've taken dbforums off line

What Tara Lyn is trying to say is yes, use SQL Server 2008 R2..you will be hard pressed to find...umm..."limits"

I know I haven't found any...enough about my personal life though...

So you want to convert mySQL to SQL Server?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

Keysle
Starting Member

15 Posts

Posted - 2010-10-08 : 16:07:56

That's what I'll have to do in the future I suppose. I just know that I need to hold more data than facebook.

http://Keysle.com
/* I am going to be on here a lot until I get my project done */

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-08 : 16:08:15

Keysle, you've posted your questions on a Microsoft SQL Server site. We do not specialize in MySql, so you should consider posting further questions in sites that do specialize in it such as mysql.com and dbforums.com.

I doubt Google has a quadrillion rows in one table. I have no idea though, but it's very doubtful that anyone has that many rows in one table.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-08 : 16:09:32

Oh and FB likely doesn't use SQL Server because it's expensive. We use CPU Enterprise edition licensing, which puts us at about $40k per server (two socket quad-core, hyperthreaded, so 16 CPUs but only license 2 sockets). Imagine how much that would cost FB amongst its hundreds (?) of servers.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

X002548
Not Just a Number

15586 Posts

Posted - 2010-10-08 : 16:11:21

Well...I've had discussion on the FakeBook Architecture...

I do not believe that it is a relational database, but a proprietary one in the manner of hierarchical database like IDMS

MOO

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-08 : 16:13:35

FB can be terribly slow during peak times, so I wouldn't target it as an example of a well-tuned system.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Keysle
Starting Member

15 Posts

Posted - 2010-10-08 : 16:14:56

OH .. i thought SQl and MySQL was all in the same family T_T.
This is how little i know.
Alright, I'll be on my way

http://Keysle.com
/* I am going to be on here a lot until I get my project done */

X002548
Not Just a Number

15586 Posts

Posted - 2010-10-08 : 16:19:37

http://www.itworldcanada.com/news/facebook-outage-caused-by-database-glitch/141577

http://www.cs.mcgill.ca/~wshu/taing/comp598_fall2007/facebook/facebook_platform.pdf

http://developers.facebook.com/

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources