MYSQL to SQL Server (MSSQL)

I've been using MySQL for 2 years, and I've always been ASP. NET + MySQL Development

Why not use MSSQL?

Reason:

In my country, I can hardly find any hosting company that provides SQL SERVER, or 2005-year version, or very high price.

I think it's strange why the United States hosting company is ASP + MSSQL but the price is so far.

To the recent project, the 2 different companies product compatibility problem is getting bigger, so, I decided to give up MySQL.

The fuse is going to start with a bug.

https://bugs.mysql.com/bug.php?id=74918

https://bugs.mysql.com/bug.php?id=72058

http://bugs.mysql.com/bug.php?id=70722

At present I use is 6.9.5 version connector, has a bug, official website said 6.9.6 will fix, then I had to retire 6.9.4, because this bug is 6.9.5 only appear.

How to know 6.9.4 also encountered a bug, said 6.9.5 will fix.

The dilemma made me very angry.

All year long connector is fine, until I start using the Entity Framework and the Web API. (So if you're not using it, it's pretty good.)

One of the problems with MYSQL is that it doesn't support DateTimeOffset (which is a lot better than datetime) and a TimeSpan (rowVersion, optimistic concurrency).

The process of replacing is not complicated.

1. The Web config for MySQL can be removed.

2. mysql optimistic concurrency is done with a TimeSpan + DateTime, MSSQL is a TimeSpan + byte

3. MSSQL DateTimeOffset Support in the insert when the SQL automatically fill in the current time, this is not available in MySQL (5.6 I am not the case, I use 5.1)

4. MSSQL's last modified DateTime must be written trigger to complete, MySQL as long as a timespan.

Big at least that's it.

So the function of MSSQL and MySQL is actually similar, are all database, should have.

But the engine and the optimization are quite different (the first day explain look at the result of the statement. = "), this I can not learn, anyway, mostly with EF production statements, later study it.

I am from the previous article on MYSQL + ASP, the difference between the two I will be updated, if you and I have the same experience hope can help you ^^

MYSQL to SQL Server (MSSQL)