SQL Server Database for Project Administrator

Buy Now

What is it?

For some years we have been asked to provide Project Administrator with a more heavy duty database back end. We can now provide a back end to run on SQL Server 2000 or 2005. The more robust design of SQL Server makes it more suitable for high volume users. It is also suitable for organisations that restrict use of Access as a database in order to control growth of data islands across the enterprise.

What does it replace?

The SQL Server database replaces the tables in the standard version of PA. The screens, reports and code are still in an Access file however the file uses data from a SQL Server back end.

Can I convert my existing data?

The simple answer is yes. It will howerver require the skills of a Data Base Administrator or someone skilled in SQL Server. There may be some manipulation of data required to correct corrupt or missing data. SQL Server is less tolerant than Access when it comes to data integrity.

Can I install it myself?

Unless you have extensive knowledge of SQL Server, we would not recommend you try and convert the data. It not only requires knowledge of SQL Server. It also requires administrator access and understanding of your security environment.

Can I use SQL Server Express?

SQL Server Express is the free download of the software. It is able to be used however there is no facility to automatically migrate data from Access.

If you are starting with a new database, you can will need to set up parameter information manually. This means transferring things like Issue Status, and Risk Probability by keying them into SQL Server

How much does it cost?

The cost for the SQL Server back end is A$450. This is in addtion to a normal purchase of Project Administrator. For example, a 5 user license including SQL Server would be A$1,000 plus $450 for the SQL Server component.

What is in the Upgrade?

The upgrade consists of three files.

• A version of PA which will prepare your Access tables to be converted
• A script to create your SQL Server database
• A script to create Foreign Keys. This is run after data conversion.

In addition we provide step by step instructions which are aimed at a person with DBA skills.

Is the data structure the same as the Access Tables?

No. There are some additional fields in SQL Server that are not in Access. From a usage point of view, this is transparent. The changes are of a technical nature.

What is involved in the conversion?

The instructions can be downloaded from our web site - DOWNLOAD It is suggested you discuss with your DBA before purchasing

What support can Project Perfect provide?

We will answer any questions you may have but most of the decisions or potential problems will relate to your own environment. We cannot assist with questions relating to security or networking issues. This is why we strongly recommend the involvement of a DBA. Your DBA is most welcome to contact us and clarify any issues prior to purchase.