Solved

Interfacing MS Project to a SQL Server database

Posted on 2006-07-18
3
8,033 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

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.
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

809 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