Does Liquibase support ROWVERSION for SQL Server 2008?

General Discussion
1

I am evaluating Liquibase for a new project we are starting and in the process I have run into a snag.


To track changes to rows in our tables we are going to use the ROWVERSION data type.


When I attempt to create a table with the ROWVERSION datatype in my change log, I see that the table is actually created in the database with a TIMESTAMP data type.


This is a deprecated data type and we don’t want to use it.


I really don’t want to have to resort to running a custom SQL tag after every table create to get this in.  Is there another way around this problem?


Our system will be using Microsoft SQL Server 2008 R2 and I generated this using Liquibase 2.0.2.




2

 I’m not seeing a reference to rowversion in the code, which should mean it would be created as rowversion and not converted to timestamp. You are seeing it as timestamp in management studio or with a database diff?


Nathan

3

Great. Thanks for the update

4

I apologize Nathan, the use of the synonym in Management Studio is what was confusing me.


The datatype shows up as a timestamp in the Management Studio, but this is a synonym for actual rowversion datatype.


Liquibase is behaving as it should.