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

Comments

Sort by recent activity
We are mid stream of doing some releases so I don't know that we will be able to fit that in. Has there been bug fixes for issues like this? / comments
  1. Community
  2. SQL Compare
  3. In SQL Compare can generated scripts do 'IF EXISTS....' check before adding columns?
We are mid stream of doing some releases so I don't know that we will be able to fit that in. Has there been bug fixes for issues like this?
0 votes
A simple default will not work for setting that column and also the column is not null and there is already data in the table. Given that complexity we needed to write a script to set the column value. RedGate cannot do that for us. The error we are getting is RedGate isn't wrapping that chunk of code in a "if exists...". / comments
  1. Community
  2. SQL Compare
  3. In SQL Compare can generated scripts do 'IF EXISTS....' check before adding columns?
A simple default will not work for setting that column and also the column is not null and there is already data in the table. Given that complexity we needed to write a script to set the column va...
0 votes
This is what we are currently doing. And it does not appear to work with the new column. [string] $RedGateOptions = "CaseSensitiveObjectDefinition,IgnoretSQLt,IgnoreUsersPermissionsAndRoleMemberships,ObjectExistenceChecks,IgnoreUsers,NoTransactions,NoErrorHandling", / comments
  1. Community
  2. SQL Compare
  3. In SQL Compare can generated scripts do 'IF EXISTS....' check before adding columns?
This is what we are currently doing. And it does not appear to work with the new column. [string] $RedGateOptions = "CaseSensitiveObjectDefinition,IgnoretSQLt,IgnoreUsersPermissionsAndRoleMembershi...
0 votes
Here is a copy of the script that was generated.  The column we added is called 'ARCo' .  Basically that entire chunk the the script should have an "if exists..." check so that it can be skipped if the column is already there. Possibly RedGate isn't putting in the appropriate "if exists..." because of various combination of not null/indexes/primary keys on the table.  Script created by SQL Compare Engine version 12.4.10.4968 from Red Gate Software Ltd at 5/24/2019 10:36:02 PM */ SET NUMERIC_ROUNDABORT OFF GO SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON GO PRINT N'Dropping constraints from [dbo].[vARStatementDelivery]' GO IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PK_vARStatementDelivery]', 'PK') AND parent_object_id = OBJECT_ID(N'[dbo].[vARStatementDelivery]', 'U')) ALTER TABLE [dbo].[vARStatementDelivery] DROP CONSTRAINT [PK_vARStatementDelivery] GO PRINT N'Dropping index [IX_vARStatementDelivery_CustGroup_Customer] from [dbo].[vARStatementDelivery]' GO IF EXISTS (SELECT 1 FROM sys.indexes WHERE name = N'IX_vARStatementDelivery_CustGroup_Customer' AND object_id = OBJECT_ID(N'[dbo].[vARStatementDelivery]')) DROP INDEX [IX_vARStatementDelivery_CustGroup_Customer] ON [dbo].[vARStatementDelivery] GO PRINT N'Rebuilding [dbo].[vARStatementDelivery]' GO CREATE TABLE [dbo].[RG_Recovery_1_vARStatementDelivery] ( [ARStatementDeliveryID] [int] NOT NULL IDENTITY(1, 1), [CustGroup] [dbo].[bGroup] NOT NULL, [Customer] [dbo].[bCustomer] NOT NULL, [Recipient] [varchar] (60) COLLATE Latin1_General_BIN NULL, [Email] [varchar] (60) COLLATE Latin1_General_BIN NULL, [Address1] [varchar] (60) COLLATE Latin1_General_BIN NULL, [Address2] [varchar] (60) COLLATE Latin1_General_BIN NULL, [City] [varchar] (30) COLLATE Latin1_General_BIN NULL, [State] [char] (4) COLLATE Latin1_General_BIN NULL, [Country] [char] (2) COLLATE Latin1_General_BIN NULL, [PostalCode] [dbo].[bZip] NULL, [DateSent] [dbo].[bDate] NULL, [DeliveryMethod] [char] (1) COLLATE Latin1_General_BIN NOT NULL, [DeliveryStatus] [char] (1) COLLATE Latin1_General_BIN NOT NULL, [UniqueAttchID] [uniqueidentifier] NULL, [ARCo] [dbo].[bCompany] NOT NULL ) ON [PRIMARY] GO SET IDENTITY_INSERT [dbo].[RG_Recovery_1_vARStatementDelivery] ON GO INSERT INTO [dbo].[RG_Recovery_1_vARStatementDelivery]([ARStatementDeliveryID], [CustGroup], [Customer], [Recipient], [Email], [Address1], [Address2], [City], [State], [Country], [PostalCode], [DateSent], [DeliveryMethod], [DeliveryStatus], [UniqueAttchID]) SELECT [ARStatementDeliveryID], [CustGroup], [Customer], [Recipient], [Email], [Address1], [Address2], [City], [State], [Country], [PostalCode], [DateSent], [DeliveryMethod], [DeliveryStatus], [UniqueAttchID] FROM [dbo].[vARStatementDelivery] .... ... ... ... .. ... ... ... / comments
  1. Community
  2. SQL Compare
  3. In SQL Compare can generated scripts do 'IF EXISTS....' check before adding columns?
Here is a copy of the script that was generated.  The column we added is called 'ARCo' .  Basically that entire chunk the the script should have an "if exists..." check so that it can be skipped if...
0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1