Solved

Interfacing MS Project to a SQL Server database

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

743 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now