# Database schemas in a multi developer environment

**URL:** <https://forum.inductiveautomation.com/t/database-schemas-in-a-multi-developer-environment/92263>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [June 23, 2024, 10:26pm UTC](https://forum.inductiveautomation.com/t/database-schemas-in-a-multi-developer-environment/92263 "2024-06-23T22:26:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![robertm](https://avatars.discourse-cdn.com/v4/letter/r/ea5d25/32.png) [@robertm](https://forum.inductiveautomation.com/u/robertm)\
**Post date:** [June 23, 2024, 10:26pm UTC](https://forum.inductiveautomation.com/t/database-schemas-in-a-multi-developer-environment/92263/1 "2024-06-23T22:26:20Z")

</div>

In the case of multiple developers developing Ignition vision projects that will all need to be merged into a final gateway encompassing a new facility, is there any advantage or disadvantage to enforcing everyone to use a single Historian DB schema or better to allow each project to have its own historian DB, and create all the various schemas as projects are imported? The DB is MSSQL on its own VM. Id prefer to keep one name for management purposes (one config for purge, backups,etc), but if there is some efficiency to be gained by splitting across multiple schemas within a MSSQL DB, I can pivot.

---

<div class="post-metadata">

**Author:** ![robertm](https://avatars.discourse-cdn.com/v4/letter/r/ea5d25/32.png) [@robertm](https://forum.inductiveautomation.com/u/robertm)\
**Post date:** [June 25, 2024, 7:30pm UTC](https://forum.inductiveautomation.com/t/database-schemas-in-a-multi-developer-environment/92263/2 "2024-06-25T19:30:52Z")

</div>

Friendly bump

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 25, 2024, 7:40pm UTC](https://forum.inductiveautomation.com/t/database-schemas-in-a-multi-developer-environment/92263/3 "2024-06-25T19:40:08Z")

</div>

I would make one database connection with one schema, unless you have a more significant reason than just developer convenience.
