Convert MS Sql Field Types and Sizes to MYSQL Ideal Field Types and Sizes

I am running to something that I am sure might be straight forward for some but for some reason its just not clicking. So I thought I would put this out there for the community to help.

The MySQL db that I am putting this in incase it helps, using MyISAM, and the Character Set: Latin1 and Collation Latin1

The MS Sql I converted Strings to CHAR and V_Strings to VARCHAR. The others though I am just wanting to make sure.

Here are the fields in question.
TYPE      LENGTH
Byte              1
Byte              1
Byte              1
Byte              1
Byte              1
Byte              1
Byte              1
Byte         1
Byte       1
Date      10
Date      10
Date      10
DATE      10
DATE      10
DateTime      19
Double       8
Double       8
Int16       2
Int32       4
Int32       4
Int32       11


Here is what I was doing.
                               Length
Byte = TinyInt      1
Int64 = BigInt              8
Int32 = Int              11
Int16 = SmallInt      2


Is this correct?  Is there a different recommendation for data type and length?
Joel BuhrPresidentAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
That looks fine indeed as per SQL datatypes:

bigint -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807) 8 Bytes
int       -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)                                              4 Bytes
smallint  -2^15 (-32,768) to 2^15-1 (32,767)                                                                   2 Bytes
tinyint     0 to 255                                                                                                                1 Byte

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Olaf DoschkeSoftware DeveloperCommented:
There is a chapter in mysql documentation about migration and mssql, see here:

https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html

The comments about subtle differences are very helpful.

Bye, Olaf.
Joel BuhrPresidentAuthor Commented:
Thank you for the quick response.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.