By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,296 Members | 1,475 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,296 IT Pros & Developers. It's quick & easy.

Internet - Intranet Data Dilema

P: n/a
Hi,

Currently, I have one database for Intranet clients on the server behind the
firewall. But I was asked to allow the extranet users to access the same
data. From the security perspective what is the best way to make that data
accessible.

Should we have two databases one for Intranet and one for Extranet? In that
case the second one would be a replica but that would cost us money for the
extra MS SQL license. Maybe it is OK to have only one physical database.
Maybe MySQL is a good idea to use as a replica that would be refreshed
nightly. Or XML data would be OK to server only extranet.

What would be the best idea to do.

We are all MS shop.

Thanks in advance for any help,
Tom
Feb 9 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Personally I would never make any SQL database available to the general
Internet community. You are asking it to be attacked if you do and believe
me, if it has any sort of usefull info stored in it someone will hack it.

You may be better off looking at some sort of front end or portal that your
customers can use (maybe a web front end or something)? Not sure if that is
possible or not but just a thought.

You mentioned XML and maybe that would be good.. Maybe something like an XML
query/update system would work?

I would try to keep ANY direct access limited to just a front end of some
sort and put that data behind a firewall, etc.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Charles Cox
VC/VB/C# Developer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

"asdf" <as**@asdf.com> wrote in message
news:HM*******************@news20.bellglobal.com.. .
Hi,

Currently, I have one database for Intranet clients on the server behind
the
firewall. But I was asked to allow the extranet users to access the same
data. From the security perspective what is the best way to make that data
accessible.

Should we have two databases one for Intranet and one for Extranet? In
that
case the second one would be a replica but that would cost us money for
the
extra MS SQL license. Maybe it is OK to have only one physical database.
Maybe MySQL is a good idea to use as a replica that would be refreshed
nightly. Or XML data would be OK to server only extranet.

What would be the best idea to do.

We are all MS shop.

Thanks in advance for any help,
Tom

Feb 9 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.