Table rebuild in sql compare13 with TEXTIMAGE_ON

• 
  Tianjiao_Li ,
  I have tried with SQL Compare 13.6.1.7928 still rebuilt is happening.
  As you commented I am trying to update my SQL Compare to 13.6.3. as could not find such version in sql toolbelt. where can i find that version can you suggest us on this. Please find my above comment to find script which we are using for sync. Below is the resulted script.
  
  Script Generated by SQL Comapare 13:
  
  

  SET NUMERIC_ROUNDABORT OFF

  GO

  SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON

  GO

  SET XACT_ABORT ON

  GO

  SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

  GO

  BEGIN TRANSACTION

  GO

  @ERROR <> 0 SET NOEXEC ON

  GO

  PRINT N'Dropping constraints from [dbo].[MANAGE_FIELD_LABEL_NAME]'

  GO

  ALTER TABLE [dbo].[MANAGE_FIELD_LABEL_NAME] DROP CONSTRAINT [PK_MANAGE_FIELD_LABEL_NAME_FIELD_LABEL_ID]

  GO

  @ERROR <> 0 SET NOEXEC ON

  GO

  PRINT N'Rebuilding [dbo].[MANAGE_FIELD_LABEL_NAME]'

  GO

  CREATE TABLE [dbo].[RG_Recovery_1_MANAGE_FIELD_LABEL_NAME]

  (

  [FIELD_LABEL_ID] [BIGINT] NOT NULL IDENTITY(1, 1),

  [FIELD_LABEL_NAME] [NVARCHAR] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [FIELD_DESCRIPTION] [VARCHAR] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [FIELD_KEY] [NVARCHAR] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [FIELD_DESCRIPTION_TEST] [VARCHAR] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

  )

  GO

  @ERROR <> 0 SET NOEXEC ON

  GO

  SET IDENTITY_INSERT [dbo].[RG_Recovery_1_MANAGE_FIELD_LABEL_NAME] ON

  GO

  @ERROR <> 0 SET NOEXEC ON

  GO

  INSERT INTO [dbo].[RG_Recovery_1_MANAGE_FIELD_LABEL_NAME]([FIELD_LABEL_ID], [FIELD_LABEL_NAME], [FIELD_DESCRIPTION], [FIELD_KEY]) SELECT [FIELD_LABEL_ID], [FIELD_LABEL_NAME], [FIELD_DESCRIPTION], [FIELD_KEY] FROM [dbo].[MANAGE_FIELD_LABEL_NAME]

  GO

  @ERROR <> 0 SET NOEXEC ON

  GO

  SET IDENTITY_INSERT [dbo].[RG_Recovery_1_MANAGE_FIELD_LABEL_NAME] OFF

  GO

  @ERROR <> 0 SET NOEXEC ON

  GO

  DECLARE @idVal BIGINT

  SELECT @idVal = IDENT_CURRENT(N'[dbo].[MANAGE_FIELD_LABEL_NAME]')

  IF @idVal IS NOT NULL

      DBCC CHECKIDENT(N'[dbo].[RG_Recovery_1_MANAGE_FIELD_LABEL_NAME]', RESEED, @idVal)

  GO

  @ERROR <> 0 SET NOEXEC ON

  GO

  DROP TABLE [dbo].[MANAGE_FIELD_LABEL_NAME]

  GO

  @ERROR <> 0 SET NOEXEC ON

  GO

  EXEC sp_rename N'[dbo].[RG_Recovery_1_MANAGE_FIELD_LABEL_NAME]', N'MANAGE_FIELD_LABEL_NAME', N'OBJECT'

  GO

  @ERROR <> 0 SET NOEXEC ON

  GO

  PRINT N'Creating primary key [PK_MANAGE_FIELD_LABEL_NAME_FIELD_LABEL_ID] on [dbo].[MANAGE_FIELD_LABEL_NAME]'

  GO

  ALTER TABLE [dbo].[MANAGE_FIELD_LABEL_NAME] ADD CONSTRAINT [PK_MANAGE_FIELD_LABEL_NAME_FIELD_LABEL_ID] PRIMARY KEY CLUSTERED  ([FIELD_LABEL_ID]) WITH (FILLFACTOR=80)

  GO

  @ERROR <> 0 SET NOEXEC ON

  GO

  SET NUMERIC_ROUNDABORT OFF

  GO

  SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON

  GO

  SET DATEFORMAT YMD

  GO

  SET XACT_ABORT ON

  GO

  COMMIT TRANSACTION

  GO

  @ERROR <> 0 SET NOEXEC ON

  GO

  -- This statement writes to the SQL Server Log so SQL Monitor can show this deployment.

  IF HAS_PERMS_BY_NAME(N'sys.xp_logevent', N'OBJECT', N'EXECUTE') = 1

  BEGIN

      DECLARE @databaseName AS nvarchar(2048), @eventMessage AS nvarchar(2048)

      SET @databaseName = REPLACE(REPLACE(DB_NAME(), N'\', N'\\'), N'"', N'\"')

      SET @eventMessage = N'Redgate SQL Compare: { "deployment": { "description": "Redgate SQL Compare deployed to ' + @databaseName + N'", "database": "' + @databaseName + N'" }}'

      EXECUTE sys.xp_logevent 55000, @eventMessage

  END

  GO

  DECLARE @Success AS BIT

  SET @Success = 1

  SET NOEXEC OFF

  IF (@Success = 1) PRINT 'The database update succeeded'

  ELSE BEGIN

  @TRANCOUNT > 0 ROLLBACK TRANSACTION

  PRINT 'The database update failed'

  END

  GO

  
  

  Varahalubabu November 20, 2018 07:34

  - 0 +

Add comment

Please sign in to leave a comment.