August 29, 2007 at 10:47 am
Hello everyone,
Here's my situation...
I'm running a web service which involves 51 seperate servers and databases.
There are fifty licensee servers (One for each US state) and one corporate server.
Each night I need to upload sales and membership data from the licensee's databases to the corporate database to compile reports.
The application platform I'm using is ASP.NET 2.0 and the the database is SQL2005 express.
I want this process to be run automatically, so I believe it's a scheduled windows service I need to setup up in .NET to make the data transfers.
If anyone has already set something up like this, or knows the steps to take? I would love to have your input.
Thanks in advance,
Robert
Phone a Babysitter.com
Connecting Parents and Babysitters Nationwide!
August 30, 2007 at 11:22 am
Robert,
If you are considering 3rd party tools, then the company I work for has a tool that allows you to query all 50 servers/databases in parallel in one click or in a completely automated or shcheduled fashion, and get one result set for each query. Query results can be written automatically to the central database, or to several central databases.
If you are not considering 3rd party tools and are looking to collect data from all servers that I would suggest to:
- If you are collecting data via asp pages, then you can create a scheduled task via .Net code using simple samples found in CodeProject.com. Just search for the string "scheduled task".
- You can also collect data using SSIS or build a customer SQL code or application. Those run on a scheduled basis using SQL Jobs.
Hope this helps.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply