"GO" batch text in SQL Compare

• 
  Hi Don
  
  Thank you for your forum post.
  
  Are you able to explain further what you are seeking in reference to the GO keyword in the deployment script?
  
  There is no option to set or influence the GO keyword. There is a GO statement after the creation or change to each object as per the simple example:
  

  PRINT N'Creating schemas'
  GO
  CREATE SCHEMA [HumanResources]
  AUTHORIZATION [dbo]
  GO
  IF @ERROR <> 0 SET NOEXEC ON
  GO
  CREATE SCHEMA [Person]
  AUTHORIZATION [dbo]
  GO
  IF @ERROR <> 0 SET NOEXEC ON
  GO
  CREATE SCHEMA [Production]
  AUTHORIZATION [dbo]
  GO
  IF @ERROR <> 0 SET NOEXEC ON
  GO
  CREATE SCHEMA [Purchasing]
  AUTHORIZATION [dbo]
  GO
  IF @ERROR <> 0 SET NOEXEC ON
  GO
  CREATE SCHEMA [Sales]
  AUTHORIZATION [dbo]
  GO
  IF @ERROR <> 0 SET NOEXEC ON
  GO
  CREATE SCHEMA [tSQLt]
  AUTHORIZATION [dbo]
  GO
  

  
  (note that @ERROR should be @ @ERROR, avoiding formatting problem with double @)
  
  OR
  

  BEGIN TRY
     EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of GETDATE()', 'SCHEMA', N'Production', 'TABLE', N'ProductCategory', 'CONSTRAINT', N'DF_ProductCategory_ModifiedDate'
  END TRY
  BEGIN CATCH
     DECLARE @msg nvarchar(max);
     DECLARE @severity int;
     DECLARE @state int;
     SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
     RAISERROR(@msg, @severity, @state);
  
     SET NOEXEC ON
  END CATCH
  GO
  BEGIN TRY
     EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of NEWID()()', 'SCHEMA', N'Production', 'TABLE', N'ProductCategory', 'CONSTRAINT', N'DF_ProductCategory_rowguid'
  END TRY
  BEGIN CATCH
     DECLARE @msg nvarchar(max);
     DECLARE @severity int;
     DECLARE @state int;
     SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
     RAISERROR(@msg, @severity, @state);
  
     SET NOEXEC ON
  END CATCH
  GO
  

  
  Many Thanks
  Eddie

  Eddie D April 05, 2017 08:25

  - 0 +

Add comment

Please sign in to leave a comment.