Version - where is it stored and what scheme to use?

[lamelyan]

Using the following to run migrations:

grate.exe --files .\scripts --databasetype postgresql --connectionstring "...'" --version 0.1.0 --silent --outputPath .\migration-output

Questions:

Where does the version get stored in the database?

What versioning scheme is recommended? I see that the version has four digits 0.0.0.0 and I am used to SEM versioning of just three major, minor, patch.

[hoangthanh28]

From what I can see, the versioning schema follows assembly version which is defined by: <major version>.<minor version>.<build number>.<revision>.
The main mechanism of grate is getting from the runtime assembly (by default) or user input via --version parameter (which you can place whatever as string).
I also catch some demand to follow the SEM version. I would suggest that you use the same version with your application. If your application is versioning follow SEM version -> use --version SEM_version in grate as well.

[lamelyan]

Thank you. I will use the SEM versioning since my other projects also use it.

Also, I found how Grate stores the versioning. In the database of course! Creates it's own tables to track things.