Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Interfacing MS Project to a SQL Server database

Posted on 2006-07-18
3
Medium Priority
?
9,003 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 2000 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
A simple overview of the possibilities of using technology for project management.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

877 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