steveouthwaite
Programmer
Hi everyone,
first a bit of background...
I have a program that is distributed across 50 sites. Data is retrieved by our central server via dial-up once a week.
At the moment, the file structure is very messy, there are seperate files containing the data for every week for every remote site. After 2 years of operation, we have 25,000 files on the server.
I am writing a major update, and would like to tidy this up before it gets out of hand. I think that using databases would be best, i.e each site will have its own local database containing its info, and there will be one on the central server containing info for all sites, with a bit of code to keep the databases synchronised.
I have a database set up on our central SQL server ready to store the data, the question is... how do I create a local database on the remote sites? I have searched through MSDN to no avail, and now I am well and truly stuck. Can anyone suggest a good place to start.
With regards
Steve
first a bit of background...
I have a program that is distributed across 50 sites. Data is retrieved by our central server via dial-up once a week.
At the moment, the file structure is very messy, there are seperate files containing the data for every week for every remote site. After 2 years of operation, we have 25,000 files on the server.
I am writing a major update, and would like to tidy this up before it gets out of hand. I think that using databases would be best, i.e each site will have its own local database containing its info, and there will be one on the central server containing info for all sites, with a bit of code to keep the databases synchronised.
I have a database set up on our central SQL server ready to store the data, the question is... how do I create a local database on the remote sites? I have searched through MSDN to no avail, and now I am well and truly stuck. Can anyone suggest a good place to start.
With regards
Steve
