Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jeff00seattle
Starting Member
5 Posts |
 Posted - 2009-02-23 : 14:08:25
|
I have just been brought into a new assignment and I do not want to re-invent the wheel if it at all possible. I am very familiar with MS SQL and ASP.NET (C#) as a middle-tier developer for Web-based solutions, but what I am not familiar with if there is an existing Business/Dev solution for connect MS Project data with MS SQL.The current Business user environment is as follows:- Manager creates a project plan using MS Project
- The project is entered manually by Manager into MS Access
- 100+ users update Access files with status of completion of tasks and subtask.
I am to provide a more robust solution because the current MS Access solution is causing User access and locking issues.I am curious if there is a way that when the Manager creating or updating the project via MS Project, that if these updates can be applied dynamically to MS SQL box via some data connectivity solution? For example, as one could perform with MS Excel?Here is an example work-flow I am contemplating:- Manager -->
- Create/update Project
- Assign tasks to Team Members
- --> MS Project
- <--> MS SQL
- <--> ASP.NET
- <--> Project Tracking Page
- <--> Team Members
- Views assigned Tasks
- Enter status and reports
Curious, any feedback would be very much appreciated!ThanksJeff in Seattle |
|
|
|
|
|
MS Project manages Project data on MS SQL