Activity overview
Latest activity by svallarian
SQL Compare deploy to Team Foundation TFS
Can sql compare not deploy directly to a folder in TFS? I'm comparing a snapshot of a database to what's in a folder in source control, and only have an option to create a deployment script. This i...
current_timestamp table default getting brought in as a function
When adding a new SQL table from a flat file, i've got the table defined like this:CREATE TABLE [dbo].[Redgate]([umEquipmentID] [VARCHAR] (30) COLLATE Latin1_General_CI_AS NOT NULL,[new_umEquipment...
I had the same issue, and it turned out there was something *else* different in the script. If there's any other differences between source --> destination, then sql compare will flag the constraint name, along with the other change. / comments
I had the same issue, and it turned out there was something *else* different in the script. If there's any other differences between source --> destination, then sql compare will flag the constrain...
User case for us is we are comparing scripts in a folder (that have semicolons -- because different developers from different companies have different coding standards) vs a snapshot of a live database. / comments
User case for us is we are comparing scripts in a folder (that have semicolons -- because different developers from different companies have different coding standards) vs a snapshot of a live data...