Using another backend

[Goofy]

Using Microsoft Project Standard or Professional 2003 ( Single User ). Is it
possible to store the project data in an SQL Database or do you have to buy
project sever to do this ?

 

[Dale Howard [MVP]]

Goofy --

Yes, you can use a SQL Server database to store both your projects and your
shared resource pool file, if you use one. You must set up a DSN in
Microsoft Project to connect to the SQL Server database. You do NOT have to
purchase Project Server for this purpose. Hope this helps.

 

[Goofy]

OK, so how do I export the table structure for the SQL server ? Presumably
there are one or more tables to be constructed before I can set up the DNS
and connect to it.

 

[Dale Howard [MVP]]

Goofy --

When you create the DSN and then save the project in the SQL Server
database, the software automatically sets up the table structure for you.
It's automatic, so there's nothing you need to do but save the project.
Hope this helps.

 

[Jan De Messemaeker]

Hi

Save As has the ODBC button.
A description of the tables is on the installation CD (projdb.htm, but this
name may be slightly different in different versions)
HTH

 

[Goofy]

Thanks, btt you had replied I had discovered this.

I now need to know if there is a way to make a top level task have a custom
field and force the user to enter a value.

Many Thanks

 

[Goofy]

Thanks Jan

Hi

Save As has the ODBC button.
A description of the tables is on the installation CD (projdb.htm, but
this
name may be slightly different in different versions)
HTH

 

[Jan De Messemaeker]

Hi,

Top level tasks having custom fields yes
Customized as summary tasks (see customize form)
Force user no, not without VBA.
HTH