1
Vote

Rowversion datatype changed to Timestamp

description

DBDiff Beta 0.8.5 and 0.8.9.61

I use rowversion datatype on my tables. This seems to get converted to timestamp in the synchronization script. Timestamp is deprecated. Rowversion is recommended.
-- ORIGINAL
CREATE TABLE [dbo].[FOO]
(
    [FooID] [int] NOT NULL,
        [Bar] [varchar(10)]
    [Revision] [rowversion] NOT NULL
)
GO

-- GENERATED
CREATE TABLE [dbo].[FOO]
(
    [FooID] [int] NOT NULL,
        [Bar] [varchar(10)]
    [Revision] [timestamp] NOT NULL
)
GO

comments

jspraul wrote Nov 20, 2013 at 2:43 PM

Thanks for reporting this issue. My best guess is that you are using SQL 2008?

datagod wrote Dec 5, 2013 at 3:50 PM

Yes, sorry. SQL Server 2008R2 Standard Edition.