I'm new to Drupal but have lots of PHP/MySQL experience. I generally build sites using CodeIgniter, a PHP platform and it is one such site that I'd like to move over to Drupal. It'll be my first Drupal site but I've decided to throw myself in at the deep end with something quite complicated!
The site is a surf forecast site which takes and interprets huge weather files from the NOAA server every day. It contains over 3,000 surf spots which are sorted in the following taxonomy:
So, the first job would be to import what are currently 4 separate tables whilst maintaining the hierarchy.
This is possibly more complicated as I have the site set up as below (for spot info / reports and photos) and would like to try and maintain these URLs - e.g:
The next issue is that the report data resides on a separate database. How difficult is it to pull this into a Drupal page?
There are plenty of other issues such as migrating photos, users etc but I figure they are a little more well trodden.
Any help or suggestions would be greatly appreciated.