Solved

Interfacing MS Project to a SQL Server database

Posted on 2006-07-18
3
8,555 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
A simple overview of the possibilities of using technology for project management.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

623 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