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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-10 : 08:28:59
|
| Alex writes "Hi there!how can i change one SQL databe to MySQL??" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-10 : 12:25:04
|
| You could use DTS for the data transfer.Tara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2003-12-10 : 13:47:16
|
| Isn't that like changing from Microsoft Word to Notepad?????MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-10 : 14:43:57
|
| That's what I was thinking. Although there are a few articles out there that suggest that MySQL is better. I've yet to seen a side by side comparison.Tara |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-12-10 : 20:26:07
|
| Yeah, it's better, if you don't want your data to be accurate:http://weblogs.sqlteam.com/robv/posts/576.aspx |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-12-11 : 07:05:28
|
| It's rumored that it's faster, but if you strip down an MSSQL database to the most basic functionality you can, it will probably be about the same.The point is are you willing to throw away data integrity to gain performance? |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-12-11 : 07:24:55
|
| It's faster for very simple applications (like those written by 16 year old PHP experts). When you don't do too many joins and the database doesn't have to check any referential integrity it will naturally be fast.The best description of MySQL I have heard is "A filesystem with an SQL interface"Damian |
|
|
|
|
|
|
SQL to MySQL