Comments
Sort by recent activity
Hi @David Atkinson , We are using the shared model. The stored procedure was added by my colleague, it should shown as new added on commit tab,instead of shown as dropped on get latest tab. The weird thing is, my colleague add about 10 stored procedures. But only one of them was shown as dropped on get latest tab, the others are shown as new added on commit tab. / comments
Hi @David Atkinson , We are using the shared model. The stored procedure was added by my colleague, it should shown as new added on commit tab,instead of shown as dropped on get latest tab. ...
Hi @David Atkinson, Yes, we modify the same database. My procedures are always fine and my colleague's procedure mostly fine, sometimes it will show on get latest tab. For example, my colleague add 10 procedures, 9 of them will shown on commit tab, but 1 of them was shown on get latest tab. / comments
Hi @David Atkinson, Yes, we modify the same database. My procedures are always fine and my colleague's procedure mostly fine, sometimes it will show on get latest tab. For example, my...
David Atkinson said:
If you do a Git pull on your instance and refresh the vomit tab, does this help?
Actually my colleague did not use sql source control, I will add his stored procedure into git repository. So I almost don't need to use git pull feature. / comments
David Atkinson said:
If you do a Git pull on your instance and refresh the vomit tab, does this help?
Actually my colleague did not use sql source control, I will add his stored procedure in...
Hi @Tianjiao_Li , I encounter the same problem months ago and I
knew I can unlink and re-link the git repository to show the new added
stored procedure, I have done this operation months ago. Actually I
have no idea how to reproduce it.
Today I encounter the same problem again, I wonder if you can fix this. It's a little frustrated to do the boring operation.
/ comments
Hi @Tianjiao_Li , I encounter the same problem months ago and I
knew I can unlink and re-link the git repository to show the new added
stored procedure, I have done this operation months ago...
Hi @David Atkinson , We are using the shared model. The stored procedure was added by my colleague, it should shown as new added on commit tab,instead of shown as dropped on get latest tab. The weird thing is, my colleague add about 10 stored procedures. But only one of them was sh / comments
Hi @David Atkinson , We are using the shared model. The stored procedure was added by my colleague, it should shown as new added on commit tab,instead of shown as dropped on get latest tab. ...
Tianjiao_Li wrote: »
Hi @chuck ,
Thanks for your patience with this issue.
Unfortunately the development team hasn't been able to prioritise this work. Given the size of the backlog of higher-priority items, it doesn't look like it's something we will fix in the foreseeable future.
However we still have it logged as SC-9791 in our internal bug tracking system and we'll reassess it again in the future. Please keep an eye on the release note!
Understand, thanks. / comments
Tianjiao_Li wrote: »
Hi @chuck ,
Thanks for your patience with this issue.
Unfortunately the development team hasn't been able to prioritise this work. Given the size of the backlog of higher-p...
chuck said:
Tianjiao_Li wrote: »
Hi @chuck ,
Thanks for your patience with this issue.
Unfortunately the development team hasn't been able to prioritise this work. Given the size of the backlog of higher-priority items, it doesn't look like it's something we will fix in the foreseeable future.
However we still have it logged as SC-9791 in our internal bug tracking system and we'll reassess it again in the future. Please keep an eye on the release note!
Understand, thanks.
Hi, I found you fix this bug in this release version
13.3.6.6375 - June 4th 2018 SC-9791: The 'DROP and CREATE instead of ALTER' option is no longer ignored when creating a deployment script. / comments
chuck said:
Tianjiao_Li wrote: »
Hi @chuck ,
Thanks for your patience with this issue.
Unfortunately the development team hasn't been able to prioritise this work. Given the size of the b...
sam.blackburn wrote: »
SQL Compare 13.1 is currently only available on our frequent updates channel (although we expect to release it to everyone very soon). To get these updates sooner, you can turn on frequent updates as described here: https://documentation.red-gate.com/display/SC13/Turning+on+Frequent+Updates
Hi,
I want to know if you have fixed this problem, or you just designed it like this.(can not use drop and create when use git as source for sql compare) / comments
sam.blackburn wrote: »
SQL Compare 13.1 is currently only available on our frequent updates channel (although we expect to release it to everyone very soon). To get these updates sooner, you c...
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...