Solved

Interfacing MS Project to a SQL Server database

Posted on 2006-07-18
3
8,156 Views
Last Modified: 2013-11-15
Microsoft Project can create an MS Access database or a MS Project database when you save the file.  Has anyone created a SQL Server database with MS Project?  Did it bring over the data model, as it does into Access, and how did you do it?  Thanks.
0
Comment
Question by:kaldrich
  • 2
3 Comments
 
LVL 10

Expert Comment

by:harisrashid
ID: 17148710
hi,

You cannot convert directly to sql server unless you have MS Project Server. But since MS Project desktop application allows saving the project as MS Access file (MDB) you can always convert the Access database to sql server.

Save the project file as Microsoft Access file (SAVE AS MDB in MS Project). Then use the Access upsizing utility to create the same database in MS SQL Server.

Follow the following steps in MS Access to upsize.

Open the Microsoft Access database (the MS project file saved as MDB)  

On the Tools menu, point to Database Utilities, and then click Upsizing Wizard.

Follow the directions in the Upsizing Wizard pages and dialog boxes, and then click Finish when you are done.  
The Upsizing Wizard will run to completion after you click Finish; there are no additional prompts.

The same database will be created in MS SQL Server.

Regards,

Haris
0
 
LVL 3

Author Comment

by:kaldrich
ID: 17148762
Haris, can you then link the original MS Project file to that SQL Server database?  Or multiple files to it, since you have the structure?
0
 
LVL 10

Accepted Solution

by:
harisrashid earned 500 total points
ID: 17156595
hi,

If by linking you mean utilizing the database through MS Project then it is only possible in MS Project Server and not through the desktop application alone.

The project server uses the database (SQL Server or Oracle) and it facilitates publishing of projects from MS Project Appliation to the Project Server. This in turn facilitates team collaboration. With Project server you can link to the Project database in SQL Server. This cannot be achieved with Project application alone.

You can however go through the same process in reverse. That is, import the database from MS SQL Server to Access. Then using MS Project select MDB files in the file type to open the file.

Regards,

Haris

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Re-planning is just as important as planning. MS Project files need to be updated regularly to reflect the current status of the project and to streamline the upcoming tasks. We have seen a lot of issues where project managers have not updated the p…
A simple overview of the possibilities of using technology for project management.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question