Posts
Sort by recent activity
alter table missing @@error check after it results in changes with no transaction
SQL Compare has generated the following:PRINT N'Adding foreign keys to [dbo].[Entity_PhoneNumber]'
GO
ALTER TABLE [dbo].[Entity_PhoneNumber] ADD CONSTRAINT [FK_Entity_PhoneNumber_Entity] FOREIGN KE...
Does DropAndCreateInsteadofAlter work for CREATES also?
We have a scenario where the target db might already have the new SP (done as an emergency fix), but the scripts generated dont know that (they are generated between 2 versions of the schema from T...
merging SSC files between branches
We use SSC control to handle static data with SQL Server, SSMS and TFS.When merging between branches, the SSC data files (the inserts!) do not get handled well by any compare tool used by Visual St...
/assertidentical isnt working as the help in my case
My cmd line is:"c:\Program Files (x86)\Red Gate\SQL Compare 13\SQLCompare.exe" /ScriptsFolderXML:D:\MISCTOOLS\RUNTEMP\WEB3_DEV_15777\SQLCompare_TFS_DEV_Procurement.xml /Exclude:StoredProcedure:Trad...
click "Commit changes" - get "Timeout expired..."
when I click on Commit changes on one of my main dbs I get a timeout expired error every time.
I have tried to relink it, but this makes no difference.
Other dbs can take a long time to link, but g...
SSC and SQL Compare doesnt notice case changes
I’ve changed a udf from
ALTER FUNCTION [dbo].[CategoriesChildrenAsXMLGet]
:
ca.Guid AS 'GUID', ...
:
END
To
ALTER FUNCTION [dbo].[CategoriesChildrenAsXMLGet]
:
ca.Guid AS 'Guid',...
:
END
Thats t...
Command line to link dbs to source control
we have 14 dbs in our application set, and linking them all up when we create a new TFS branch is a bit painful.
the SSC command line does lots of things but it is missing the ability to link a db ...