I have been speaking to someone who's very interested in using SharePoint for his field service business because he likes the collaboration aspects of it, and since it would be an external facing portal, he can finally get real time participation, and data, which his current software does not offer. However, the big problem is that he wants his old data from his current software to be imported into SharePoint. I know that theoretically, this can be done with two different software apps that both use sql, as long as one matches the schemas correctly (big task). But it seems to me that SharePoint would be an entirely different story because it creates it's own sql content database in a very specific manner, so even if I knew the schema of the other software and extracted it's data, I have no idea how this could possibly be bolted into SharePoint as it doesn't seem to me to merely be a matter of adding the tables and data into the content database and then expecting SharePoint to be able to reference that.
I know most would probably not even attempt this, but is it even remotely or theoretically possible to do this or are their some very good and specific reasons why this can't be done? Thanks.