Project Server DB

Hi all,

I have a problem here, i want to update the DraftDB in Project Server from an exteral DB (which is not within the Project Server architecture). How can go about doing this?

-the exteral DB would have similiar Tables with the DraftDB such as having a Table call Sponsor
-if i add a new record, edit a record, or delete a record on Table Sponsor on the exteral DB, the update would reflect to the DraftDB in Project Server?

Is there any PSI calls that capable of achieving this? Any ideas? (If you couldn't help, would you have any suggestions of who/where i should turn to?)

Thanks a lot
Michael

This seems like a job for SQL Server Agent. You should be able to do your cross-db queries and inserts through the agent.

http://technet.microsoft.com/en-us/library/ms187061.aspx

Hope this helps,

John

|||Hi,

i don't really get it.

Thanks
Michael