I want to export data form Project to a Table in SQL

[Maryori Felizola]

Hello, I am currently working as a Project Web Access Administrator and now I
have a idea for my company. I’m interested in writing a script for the asp
pages for Project Web Access to export some data to another table and report
the hours spent in each project and resource.

The thing is, we have a program where we should report our activities every
day, but we are missing where to put in the hours spent on each project
automaticaly.

My idea is that every time we report an activity into the project Web
Access, my script can wirte the same data into de table (SQL Tables) of daily
activities.

My question is if this idea can be done or should I desist it altogether, or
maybe there are some Microsoft developers who can make this change or if I
can take a course here in Mexico related to this matter.

 

[Ed Morrison]

I don't think you need to write an ASP script. There are several easier and
safer ways, depending on your needs. You can create a trigger on the
project table to write the information to your other systems table. Or you
can create a schedule batch job in SQL to select the project server data and
write it to your other system. If the data is only for reports, you can
create a query that reads data from both databases.