Comments
Sort by recent activity
Hi @Tianjiao_Li ,
This is the deploy script I get from sql compare, and I am pretty sure that I have checked “use drop and create instead of alter”.
However, the options did not work.
You can test it by yourself to confirm it.
It's very simple to reproduce it, just create a new database,and add a stored procedure to database and commit it.
Then modify it,and commit it again.
Then you can use sql compare to generate the script by compare two commits in git repository. 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
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[ProcedureName]'
GO
IF OBJECT_ID(N'[dbo].[ProcedureName]', 'P') IS NOT NULL
EXEC sp_executesql N'-- =============================================
-- Author: Chuck Lu
-- Create date: 2017-10-27
-- Description:
-- =============================================
ALTER PROCEDURE [dbo].[ProcedureName]
-- Add the parameters for the stored procedure here
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT Id ,
Age ,
NAME FROM dbo.Test
END
'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
COMMIT TRANSACTION
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
/ comments
Hi @Tianjiao_Li ,
This is the deploy script I get from sql compare, and I am pretty sure that I have checked “use drop and create instead of alter”.
However, the options did not work.
You can test...
I have found the latest version for sql compare is 13.1.0.5287 - October 16th 2017 from release notes
But when I use check for updates, the program can not found the newer version.
The latest version of sql source control is6.0.2.6908 - October 17th, 2017 ,but the program still can not check this update / comments
I have found the latest version for sql compare is 13.1.0.5287 - October 16th 2017 from release notes
But when I use check for updates, the program can not found the newer version.
The latest versi...