User profile for Varahalubabu – Support

Activity overview Badges (0) Posts (2) Comments (4)

Comments

Thank you for response, we have verified with version you suggested and it is working now. / comments

Thank you for response, we have verified with version you suggested and it is working now.

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

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

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

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

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

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: February 06, 2025 08:45
Member since: February 06, 2025 08:44

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 2