Currently we are running a case management system in our law firm. It's running on a SQL server (Microsoft SQL Standard Edition 2008)
I would like to create an extranet for customers, enabling them to view some of the case information we have in our system.
Is that possible, and if it, what is the safest way to setup an extranet.
I was thinking of two ways:
1. The website can access our SQL directly
2. Our server pushes the relevant data to the website, running MySQL. I don't know if that is possible. In that way there should be no access from the website to the server, only the other way around.
Hope some of you can give me a hint,