ASP Application Setup Best Practice

J

JP SIngh

Hi All

We have recently developed a document management application for internal
use. Initially it was supposed to be used by a single office location but
now we been asked to implement it in another office location based in
another country.

The application uses SQL Server backend, ASP frontend and also stores the
documents uploaded in a folder on the server.

It all works okay at present but when we do implement in the different
country. The network is setup such that all the servers are accessible
internally

1. Should we simply as the users in that country to access our IIS Server.
This created a potential problem that when when they upload and download
document it will have to uloaded and downloaded to the server here in London
access to which will be slower.

2. We plan to setup the second site by using a local webserver and altering
the asp code to upload the files to thier local server and also setting up
the local sql server which replicated the data from our main server.

First Question : Is this approach a good one?

Second Question : How do we maintain the integrity of the Order Number
column which is set to Indentity type so it automatically generated a new
order if when a new order is created.

Hope to find some answers

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,995
Messages
2,570,236
Members
46,825
Latest member
VernonQuy6

Latest Threads

Top