Upgrade the PM database structure. Need some SQL

Spider Project is most functional and powerful professional project management software.

The first SP version was launched in 1993 and since then it has been constantly improved. Today is used in 34 countries though most Spider Project customers are in Russia. Spider Project offers numerous unique functional features and is the only PM software that optimizes resource, cost, and material constrained schedules and budgets for projects and portfolios.

The unique features of Spider Project include Quantity Based Scheduling, Conditional Scheduling, Skill Scheduling, Optimal Resource, Cost and Material Leveling, Resource Critical Path Calculation, Cash and Material Flows Calculation and Management, Trend Analysis, Advanced Risk Simulation and Analysis, Calculation of Success Probability Trends, Calculation and Management of required Project Time and Cost Buffers, Application of Corporate Norms, Management of many Parallel Budgets, Multiple WBS and many others.

Spider Project was and is used for management of many large scale programs in Russia, including $51bln construction program for 2014 Winter Olympic Games preparation.  

Please visit us at our official website https://www.spiderproject.pro/

The application areas where Spider Project is successfully used include Aerospace, Banking, Construction, Defense, Energy, Engineering, Infrastructure, Manufacturing, Metallurgy, Mining, Oil & Gas, Railways, Retail, Shipbuilding, Software Development, Telecommunications, Utilities, etc.

Check out our Partner - Emerald Associates

• P6-Loader - Automate Primavera P6 data loading and updating from Excel
• P6-Reporter - Simplify data snapshotting and self-serve reporting
• P6-Scrubber - Import XERs and XMLs into Primavera P6 with ease
• P6-QA Tool - Automated quality control for your Primavera P6 schedule and processes
• P6-Calculator - Automated Primavera P6 calculations that go well beyond out-of-the-box functionality to give you what you need
• TAPS (Turnaround Progressing System) - Update Primavera P6 with a barcode scanner or mobile device
• CAPPS (Capital Project Progressing System for P6) - Make Primavera P6 status updates easier and faster for the whole team
• P6-Auditor - Display information from Primavera P6 audit tables in a user-friendly format
• Unifier-Archiver - Extract and archive important documents and attachments from Primavera Unifier
• Unifier-Loader - Load data into and out of Unifier via Excel
• PCM-Loader - Import data into Primavera Contract Management with flexible and secure, template-driven Excel spreadsheets
• PCM-Archiver - Extract and archive important documents and attachments from Primavera Contract Management
• PCM-Unifier Migrator - Automatically transfer live and historical data from Primavera Contract Management to Primavera Unifier with ease

Create Radically Better Construction Schedules with ALICE Technologies

Use the power of AI to create construction schedules that reduce risk while cutting costs and build time. With ALICE, develop the ideal schedule during preconstruction -- or recover projects that are off schedule and over budget.