# Database versioning

**URL:** <https://forum.manager.io/t/database-versioning/30321>\
**Category:** Uncategorized\
**Created:** [September 1, 2020, 1:14pm UTC](https://forum.manager.io/t/database-versioning/30321 "2020-09-01T13:14:06Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![d3mad](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/d3mad/32/3963_2.png) [@d3mad](https://forum.manager.io/u/d3mad)\
**Post date:** [September 19, 2020, 4:52am UTC](https://forum.manager.io/t/database-versioning/30321/3 "2020-09-19T04:52:41Z")

</div>

I use linux and OSX, on both I have the command line utility for `sqlite3`, I’m sure windows probably has something. I created a `bash` script that allows me to pass in numerous manager databases and it pulls out the schema version.

The command line is simply:

```
sqlite3 "$file" "select hex(Content) from Objects Where Key = 'a9a71e47-82b3-49db-8aec-898adb460a80'"

```

where `$file` is the filename you want to inspect. If you have special characters in the name (like spaces and or parenthesis) make sure to enclose it in double quotes to avoid errors.

I am not sure if the UUID is the same for everyone, I assume it is, but it it’s not, it’s not too hard to find.

The query will result in 6 hex characters on the display, it appears to me as `08F201`. You will find the middle byte (`F2`) is the schema version (`0xF2 = 242`) which is the current version I am running on in 20951

---

_[View the full topic](https://forum.manager.io/t/database-versioning/30321)._