Support for accessing Project Server Databases

We are looking at performing SQL queries to access data held in Project Server. I am just wondering if there are any rules surrounding which databases are allowed to be accessed in this manner.

I know we can access the Reporting database, but not sure what the licensing/support restrictions are surrounding the Published, Draft and Archive databases.

Is there anyone out there who may know or point me in the right direction.

We are still using Project Server 2007 owner will be updating to 2013 shortly.
cooperal31Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PortletPaulfreelancerCommented:
I do not know the full answer - but can give you a generic response from a vendor support perspective:

a. under no circumstances should you amend data by direct sql actions
b. performance impacts by running sql queries against the source tables would be at your risk i.e. not a support issue

You might need to refer to the EULA (or its equivalent) for more specific conditions - particularly if there might be special conditions for your organization.

{+edit} potential for locking tables also needs to be considered and if caused by your queries would be denied as a support issue
0
Rainer JeschorCommented:
Hi,
in Project Server 2007  as well as in Project Server 2013 the only supported way to query the database is the Reporting database (in 2007) / the reporting tables/views (Schema dbo).
In Project Server 2013 all four previous existing databases are now merged together into one database - using different schema for identification:
- draft. (the old draft db)
- pub. (the old published db)
- ver (the old archive db)

See:
http://msdn.microsoft.com/en-us/library/office/ee767690.aspx

HTH
Rainer
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.