# Version control & deployments discussion

**URL:** <https://community.dremio.com/t/version-control-deployments-discussion/2402>\
**Category:** Uncategorized\
**Created:** [December 7, 2018, 11:45am UTC](https://community.dremio.com/t/version-control-deployments-discussion/2402 "2018-12-07T11:45:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![matta](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/matta/32/264_2.png) [@matta](https://community.dremio.com/u/matta)\
**Post date:** [December 7, 2018, 11:45am UTC](https://community.dremio.com/t/version-control-deployments-discussion/2402/1 "2018-12-07T11:45:46Z")

</div>

Is there a recommendation for deployment processes, including version control etc.

The options I see for deploying from staging to production

1. Make a [backup](https://docs.dremio.com/advanced-administration/backup.html) of staging and [restore](https://docs.dremio.com/advanced-administration/restore.html) that into production.
2. Use docker and deploy the staging image to production.

Ideally I’d like to have some version control of dremio SQL using github. Is that possible?

A rough process that I’d like to have for developing on Dremio would look something like the following.

1. Develop new features locally, commit the new SQL code to github for review
2. Others can pull the SQL from github, test and review
3. Deploy new reviewed SQL to staging environment, run final tests
4. Deploy tested code to production

Something similar for Dremio config changes, where any change to the system settings are also tracked on github.

Is there a guide or precedent for this?  
Is the SQL stored in an open format so that I can deploy code manually?  
Thanks!

---

<div class="post-metadata">

**Author:** ![matta](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/matta/32/264_2.png) [@matta](https://community.dremio.com/u/matta)\
**Post date:** [December 14, 2018, 2:30pm UTC](https://community.dremio.com/t/version-control-deployments-discussion/2402/2 "2018-12-14T14:30:17Z")

</div>

Is there any precedent for version control in Dremio?

---

<div class="post-metadata">

**Author:** ![anthony](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/anthony/32/670_2.png) [@anthony](https://community.dremio.com/u/anthony)\
**Post date:** [December 17, 2018, 2:29pm UTC](https://community.dremio.com/t/version-control-deployments-discussion/2402/3 "2018-12-17T14:29:33Z")

</div>

Dremio has “version control” per VDS object in our interface. It is seen with the right dots on the right side of the screen. We keep a record of all (SQL) actions done to a VDS and users can review/test by sharing. This is automatically stored in our metadata storage but unfortunately is not exportable today.