Database Management - Prod Denodo 7.0 , Denodo 6.0 , Denodo 5.5 , Denodo 5.0
A Virtual DataPort database is equivalent to a virtual schema, and therefore the unit of project work in Denodo Platform. The following suggestions apply regarding database management:
- Do not mix development and production schemas in the same server.
- Test new modifications in a different schema in the same server before applying these modifications to the production schema. If a dedicated pre-production server is available, use it for these purposes.
- Do not mind replicating views among diverse virtual schemas if this makes sense for your application needs. Give applications/clients what they need and no more.
- Always apply source control tags to the production versions of your virtual schemas’ metadata.