troubleshooting Question

Extranet for clients - SQL/Mysql

Avatar of Zoodiaq
Zoodiaq asked on
Web DevelopmentMySQL ServerMicrosoft SQL Server 2008
4 Comments2 Solutions340 ViewsLast Modified:
Hi experts

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,


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros