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 |
|
mark_smith
Starting Member
8 Posts |
 Posted - 2007-05-15 : 02:48:29
|
| Hey Guys, are you aware of anyone moving from MYSQL to MSSQL or vice versa - what were your experiences - Mark Smith |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-16 : 02:52:51
|
| You might want to re-edit your subject - e.g. to "MSSQL and MySQL" - for folk that are just browsing the subjects ... |
 |
|
|
mark_smith
Starting Member
8 Posts |
Posted - 2007-05-17 : 16:53:37
|
| Thanks |
|
|
|
mark_smith
Starting Member
8 Posts |
Posted - 2007-05-17 : 16:55:28
|
| Also, is there a specific way of editing the subject? or do i need to post it all new? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-19 : 07:09:31
|
| Press the "Edit reply" Icon on your initial post (only you can do this, and you need to be logged in!) |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-06-03 : 09:18:37
|
quote:
Originally posted by mark_smith
Hey Guys, are you aware of anyone moving from MYSQL to MSSQL or vice versa - what were your experiences - Mark Smith
I have moved several databases between mysql and mssql with great success. The biggest issue we have run into is that on MySQL the InnoDB storage engine uses row level locking, whereas MSSQL will escalate locks to page level. We experienced more disruptive database blocking on the SQL Server system when using the same frontend code because of this.-ec |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-05 : 04:42:58
|
| Interesting. In my Apps I've never really found the need to worry about the effect that [absence of] row level locking would cause. Have I just been lucky?Kristen |
|
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2007-06-11 : 01:03:45
|
| Eyechart - Does the locking issue go away if you use the multi-row versioning in 2005? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-06-11 : 11:32:20
|
quote:
Originally posted by LoztInSpace
Eyechart - Does the locking issue go away if you use the multi-row versioning in 2005?
yes, this helps a great deal. Most of my migrations were from MySQL 3.x or 4.x to SQL 2K and not SQL2K5 though. -ec |
|
|
|
|
|
|
MYSQL to MSSQL