I am about to begin a redesign of my company's corporate website (not the blog). The last 3 iterations have been built on a 100% MS platform: IIS, MSSQL, and ASP with VBScript. The content management side is all custom. It's clear that the WordPress publishing tools far outstrip what I could custom-build given my time consraints, so I have begun looking seriously at basing the new site entirely on WP.
The challenges will be migrating some of the structured content into the WordPress DB. Some content like news is a no-brainer: title, body copy, occasionally an embedded image. But we also have a large directory of professionals that requires many more fields like phone number, email address, education, office, city, etc. I've looked at the custom field template possibilities in WP and it looks like this may be the route to take, though importing these records from the MSSQL DB gets foggy since the fields don't map directly.
I'm just looking for a little advice from any of you experts. Does this project seem feasible to you? Or would the time spent monkeying with the migration be a net zero (or net loss) versus writing all new custom content management tools?