How can we help you today? How can we help you today?
Varahalubabu
Activity overview Badges (0) Posts (2) Comments (4)

Activity overview

Latest activity by Varahalubabu

Thank you for response, we have verified with version you suggested and it is working now. / comments
  1. Community
  2. SQL Compare
  3. Table rebuild in sql compare13 with TEXTIMAGE_ON
Thank you for response, we have verified with version you suggested and it is working now.
0 votes
Hi, Thank you for your response. If we use Ignorefilegroup option it doesn't rebuild if we omit TEXTIMAGE_ON keyword in script. Can you check the script files which i have used for this issue in above comments. If source and target doesn't have any changes except file group even if script has  TEXTIMAGE_ON keyword table rebuild doesn't happen. Now add new column in to table in the source trying to sync you can see table rebuild. For your reference you can use above scripts to replicate the scenario.  / comments
  1. Community
  2. SQL Compare
  3. Table rebuild in sql compare13 with TEXTIMAGE_ON
Hi,Thank you for your response.If we use Ignorefilegroup option it doesn't rebuild if we omit TEXTIMAGE_ON keyword in script.Can you check the script files which i have used for this issue in above...
0 votes
Hi Thank you for your response, Because of this issue we could not  able to take decision on DB Sync automation.  I have tested in SQL Compare v13.6.4.8.8181 and SQL Compare v12.3.3.4490  Result of SQL Compare v12.3.3.4490 : 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'Altering [dbo].[MANAGE_FIELD_LABEL_NAME]' GO @ERROR <> 0 SET NOEXEC ON GO ALTER TABLE [dbo].[MANAGE_FIELD_LABEL_NAME] ADD [FIELD_DESCRIPTION_TEST] [VARCHAR] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 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 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 For above results i have used below command line syntax: C:\Program Files (x86)\Red Gate\SQL Compare 12>SQLCompare.exe /transactionIsolationLevel:SERIALIZABLE /include:staticData /exclude:Additional /scriptFile:"D:\Work\Office\SQL\RedGate\SqlComapre\CommandLine\WithoutOption\TESTFG\CompleteMigrateSql.sql" /showWarnings /include:Identical /report:"D:\Work\Office\SQL\RedGate\SqlComapre\CommandLine\WithoutOption\TESTFG\isa2y4hu.xml" /reportType:Xml /assertidentical /force /OutputWidth:1024 /scripts1:"D:\RedGateRandD\RedGateScript" /server2:AHS-LP-196 /database2:SyncDB /out:"D:\Work\Office\SQL\RedGate\SqlComapre\CommandLine\WithoutOption\TESTFG\qua10g3s.log" /options:cfgps,dp2k,nc,f,icc,idsn,IgnoreTSQLT,iu,IgnoreUserProperties,iw,iweo,incd,tofpf,ucl,ifg Result of SQL Compare v13.6.4.8.8181 : /*     Generated on 22/Nov/2018 11:51 by Redgate SQL Change Automation v3.1.1.2920 */ 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 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 For above results i have used below powershell line syntax: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -NonInteractive -ExecutionPolicy Bypass -File "D:\RedGateRandD\Docs\RedGateLib\SqlChangeAutomationRunner.ps1" sync -databaseUserName user1 -databaseServer AHS-LP-196 -options "ifg" -transactionIsolationLevel Serializable  -package [image] \RedGateRandD\RedGateScript -databaseName SyncDB -databasePassword @pword@ -scriptFile [image] \Work\Office\SQL\RedGate\SqlComapre\CommandLine\WithoutOption\TESTFG\CompleteMigrateSql.sql  -RequiredProductVersion latest / comments
  1. Community
  2. SQL Compare
  3. Table rebuild in sql compare13 with TEXTIMAGE_ON
Hi Thank you for your response,Because of this issue we could not  able to take decision on DB Sync automation. I have tested in SQL Compare v13.6.4.8.8181 and SQL Compare v12.3.3.4490 Result of SQ...
0 votes
Table rebuild in sql compare13 with TEXTIMAGE_ON
  1. Community
  2. SQL Compare
Table rebuild is happening when TEXTIMAGE_ON is there in the table creation statementif source and target have different file groups. It is happening in  SQL Compare13 but not in SQL Compare12 even...
2 followers 7 comments 0 votes
Table rebuild in sql compare13 with TEXTIMAGE_ON
  1. Community
  2. SQL Compare
Table rebuild is happening when TEXTIMAGE_ON is there in the table creation statementif source and target have different file groups. It is happening in  SQL Compare13 but not in SQL Compare12 even...
0 followers 0 comments 0 votes
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 / comments
  1. Community
  2. SQL Compare
  3. 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. wh...
0 votes
Total activity
8
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2