General Development Information

All development projects in the cloud must follow specific development rules.

Failure to follow these rules will result in your development project not being promoted to your Production Environment.

Customers migrating existing on premise development packages into the cloud are also subject to these rules. Customers should plan to re-factor any existing development packages to adhere to these rules as part of their overall cloud migration plan.

  • All extensibility tables/triggers/stored procedures will reside in the transaction database.
  • Non-extensibility-related tables/triggers/stored procedures will reside in the transaction database.
  • Deltek does not support deploying extensibility packages or non-extensibility-related packages in a separate database or schema.
  • All Web services must be developed as Generic String Based Web services.
  • Prescribed naming standards must be followed.
  • Include all create scripts for tables and stored procedures in the Extensibility package.
  • Create scripts for tables must check for the existence of the table and only create it if it does not exist.
  • Stored procedure scripts must check for the existence of the stored procedure and delete the previous before replacing.
  • Table and stored procedure scripts must not contain any schema name prefixes in front of table names.
  • Square brackets are not supported. It is MS specific syntax that should be avoided.