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
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