I plan to overhaul our Carolina Tiger website with Drupal. In our current setup, we have our primary website on a Windows based server (for minimal .Net forms) and our online gift shop on a linux server. I plan to install Drupal and eventually move our primary website to the Linux server, as it already has a security certificate that will be useful.
We need to keep our existing online store, as it already syncs well with our physical location's POS, so moving the store is not a good option.
I'd like to use the store's existing mySQL database for the Drupal installation as well. It seems like this would keep my data far simpler- we already have users that have a login- so finding a way to integrate the store's users with Drupal site users would be ideal. I imagine this would make managing the look of the store easier as well. I'm still learning to use Drupal, so I don't yet have a good understanding of underlying database structure.
- Can this be done? Is it advisable?
- Can you suggest some good resources to compare Drupal's database structure with the store's structure?
- Any pitfalls I should keep in mind?