Re: Leveling by ID vs. "Standard"

Well, it does in fact track information of those three entities. In a
very real sense, what Project calls "tables" are actually database views
of the underlying tables - filtered views of the underlying table
showing selected fields and selected records of interest same as you
might get as the output of a query in Access. In a simplified
description of what it's doing under the hood, we have a Tasks table and
a Resources table, related to each other many-to-many using the
Assignments table as the join intermediate, very much like the classic
Students, Classes, and Enrollments model I present to my beginning
database students. But it's not just one table each - in fact, you can
save the project as an mdb file and see all the individual tables by
opening the file in Access. And Access is of course an SQL database
product supporting queries created with SQL. But be forwarned - it
normalizes each entity into a total of somewhere around 50 separate
related tables and the meaning of the fields are sometime quite
cryptic - don't have the schema right in front of me but it is
documented on the CD and in the programs folder.

Yes, Project Server runs with SQL Server, in fact SQL Server is a
required component of the install. But AFAIK it doesn't give you direct
access to the table via SQL.- not a server guru so perhaps someone else
can chime in on that.

No offense meant here but I think one of the problems you may be having
stems from approaching MS Project from an IT application frame of
reference in the first place. It's simply not an IT application that
can be 'black-boxed' and deployed to the firm in the same sense that you
might deploy MS Word with a collection of templates and macros as part
of the firm's document preparation standardization initiative. If you
continue the parallel with Word, Word doesn't require you to have the
skills of a professional writer to know everything there is to know
about it's operation. But MS Project is another breed of critter
altogether. The essential skills required in using Project effectively
have nothing whatsoever to do with programming or computer skills or any
of the other Computer Application things that techno-weenies like me
love so much to play with. The essential tools are the human,
strategic, and tactical planning skills of the manager, MS Project is
simply a job aid to help you leverage those skills.
--
Steve House
MS Project MVP
Visit http://www.mvps.org/project/faqs.htm for the FAQs


"Jim Rodgers" <JimRodgers@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AE7373CF-B051-4F7C-A539-60477FC53F33@xxxxxxxxxxxxxxxx
I tell you what.
I'd be great if Project had a SQL interface !

Suppose there was a table called [Tasks]
and another called [Resources]
and another called [Assignments]
ING
...then to get a list of appointment for both the judges
and the musicians would be a simple 3 minute
GUI exercise in MS Query.

Of course, MS Query is another cool MS product.

"Real" database guys would rather just type in the
SQL query for the view they want. In this case it
would look like this...

"SELECT
Resource_Usage.Resource_Name,
Resource_Usage.Task_Name,
Resource_Usage.Start,
Resource_Usage.Finish,
Resources.Resource_Name AS Room
FROM
(Resource_Usage
LEFT JOIN Tasks
ON Resource_Usage.Task_Name
= Tasks.Task_Name)
LEFT JOIN (Resources
RIGHT JOIN Assignments
ON Resources.Resource_Name
= Assignments.Resource_Name)
ON Tasks.Task_Name
= Assignments.Task_Name
WHERE
(((Resource_Usage.Resource_Name) Not Like "* Room")
AND
((Resources.Resource_Name) Like "* Room"))
ORDER BY
Resource_Usage.Resource_Name,
Resource_Usage.Task_Name,
Resource_Usage.Start,
Resource_Usage.Finish
;"

...where [Resource_Usage] is another view
defined by this...

SELECT
Resources.Resource_Name,
Tasks.Task_Name,
Assignments.Start,
Assignments.Finish
FROM
Tasks
RIGHT JOIN (Resources
LEFT JOIN Assignments
ON Resources.Resource_Name
= Assignments.Resource_Name)
ON Tasks.Task_Name
= Assignments.Task_Name
ORDER BY
Resources.Resource_Name,
Tasks.Task_Name,
Assignments.Start,
Assignments.Finish
;"

Just THINK of what you could do!

:-)

Hey,

1. Does Project Server run on SQL Server?
2. Does Project Server give you SQL access?

If you scrolled down far enough to answer this
question, then I really am proud of you. Still, is
there any way to see Project tables?

Thanks, Jim




.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)