Yes, you are in the right place. To answer your question, it would depend on how much data you intend to import. If you only intend to stay less than a billion detailed records or under 500 GB, then either should be fine. If you are going to go higher, then I would encourage you to use Microsoft SQL Server Enterprise with our DB partitioning enabled.
Yes, there are pros and cons to both, but the only ones that make a difference are regards to scaling.
- relativly fast
- Doesn't scale above 500 GB well.
- Requires equal ammount of free disk space to DB size. This is because reindexing and defragmenting of the data files effectively copies data in the existing tables to new files. This is a limitation of the MyISAM storage engine.
MS SQL pros:
- Scales great
- Doesn't have free disk space limitations as MySQL
MS SQL cons: