SQL SERVER REPLICATION TO HOSTED DEDICATED BOX

[Guest_imported]

Hello ok I need a good answer on this one very important. Here is what I am trying to do. We have a internal environment that runs SQL Server 2000 out to applications on the internal network. We are about to setup a web presence to allow customers to place online orders through the web. The idea we have is to set this up with a dedicated host environment. One question do you think we will need two seperate boxes, one for the SQL Server 2000 replication and one for the web IIS box? What we are trying to do is as follows.

Users will login to the web interface which obviously pulls the ASP pages off the web box on the dedicated host. The order information will be stored in the hosted SQL Server 2000 database. Here is the issue we are trying to think about.

When users place orders we need to real time retrieve the order information into the internal SQL Server 2000 box to do things with that order internally. So I see this I guess as replication to that box, but my questions are about if firewall is needed, how will this information come through real time? Can replication handle this and is it encrypted etc. Thanks alot everyone.

 

[aalmeida]

If it needs to be real time replication is not a good solution.
I would work a little more into the app to make sure it does that part as well (i.e. the real time stuff).
That are things that you can use like RPC that keeps the behind the sceenes away from the eyes. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"