Data Compare does not sync sequences on Microsoft SQL

• 
  Can you please check if there is any filter that filtering out this sequence by any chance?

  Tianjiao_Li May 30, 2019 12:35

  - 0 +
• 
  no filters set.
  Also another thing I discovered when doing a data compare/deploy.
  I copied records from a source table , for example highest identity id was set to 28000.
  When I now add records in the destination table , its identity id continues from 1000.
  Meaning the compare/deploy did not reset the offset identity seed of my table
  

  dirkbru June 06, 2019 08:13

  - 0 +
• 
  Tianjiao, I'm not aware of any filters in SQL Data Compare, only a list of options where nothing is mentioned about sequences.

  
  

  Just to be clear what we mean with sequences:

  https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-2016
  

  
  

  Code snippet for our sequence object:

  CREATE SEQUENCE [dbo].[a_seq_example] <br>&nbsp;AS [BIGINT]<br>&nbsp;START WITH 1<br>&nbsp;INCREMENT BY 1<br>&nbsp;MINVALUE -9223372036854775808<br>&nbsp;MAXVALUE 9223372036854775807<br>&nbsp;CACHE <br>GO

  It seems as if redgate is unaware of the sequence object and it is not syncing (or taking into account) the properties of the sequence object in sys.sequences.

  
  

  Can we get some clarification on how redgate data compare deals with sequence objects? This is important for us to know. If redgate product suite is incompatible with sequences we need to rethink our database design or look for other solution.
  

  gemu June 06, 2019 10:24

  - 0 +
• 
  @dirkbru @gemu
  
  The development team has confirmed that SQL Data Compare doesn't support sequence like we do in SQL Compare.
  
  I couldn't find any similar suggestions on our user voice forum, so please feel free to add yours https://redgate.uservoice.com/forums/147879-sql-data-compare 
  
  Thanks.

  Tianjiao_Li June 12, 2019 10:14

  - 0 +

Add comment

Please sign in to leave a comment.