Deleting Artifacts

J

John Cello

I'm working at a client site, and am seeing bits and pieces of projects
strewn throughout the tables. My guess is they have deleted things in other
than the appropriate manner (I'm thinking with an ODBC connection and access).

The table schema doesn't really give me what I need to develop a script to
run on SQL Server to clean this mess up. Is there a good document anywhere
that has the table relationships, etc., or a script out there to clean up a
mess?

I've considered saving the projects to files, emptying the tables, then
importing them back in, but there are a LOT of projects and I'd really like
to avoid this.

Thanks in advance.
 
B

Ben Howard

Hi John
You don't mention what version you are using.

If 2003, the database is partially documented in a .chm file, though I
cannot find the ref for it.

If 2007, then the only database documented is the reporting one, and this is
probably in the SDK.

Either way, I think you have a very hard task ahead to get back to a state
where the integrity of the system is assured. I've not come across any
scripts to clean things up, and there is no supported method by MS other than
the UI (or PDS/PSI interfaces).

I would find the culprit, stop what is happening, and cross my fingers. Not
the most useful advice, but the best I have.
 
J

John Cello

Ben:

Guess I should have told you before - PS2003, PPro2003.
All the bad stuff is over a year old. I've actually got the file you're
talking about from the toolkit, but you'd need a billboard to print it out
on, and it doesn't clearly show the dependencies.

I'm going to give it another couple of days and if nobody else has a better
idea I'm going to start offloading projects to file for importing after I
flush the tables.

Thanks for trying.
 
G

Gary L. Chefetz [MVP]

John:

The full off-load might also include some project therapy, like forcing a
rebuild on all the binaries. Otherwise, it's your safest bet. Anything less
is risky.Yes, you can do this manually, but if you're a programmer, and the
job warrants it, you can automate a lot of the work as well.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
 
Top