Activity overview
Latest activity by Tom_Philbrick
Please close/delete, resolved somehow, not sure how but got changes back in our source control. / comments
Please close/delete, resolved somehow, not sure how but got changes back in our source control.
The error log shows: # Beginning transaction # Truncating __SchemaSnapshot Msg 2627, Level 14, State 1, Server D1710506, Line 31 Violation of PRIMARY KEY constraint 'PK___MigrationLog'. Cannot insert duplicate key in object 'dbo.__MigrationLog'. The duplicate key value is (26e3ec02-1b1f-5dcd-81ad-f3edf77adf73, 2020-02-26 13:55:27.0803087, 91FC73CFB749BE9865D9B9CFDBA4ACE569BE35FB93524AC709503F247B5E7366). / comments
The error log shows:# Beginning transaction# Truncating __SchemaSnapshotMsg 2627, Level 14, State 1, Server D1710506, Line 31Violation of PRIMARY KEY constraint 'PK___MigrationLog'. Cannot insert d...
Cannot insert duplicate key in object 'dbo.__MigrationLog'.
Hello,I am getting " Cannot insert duplicate key in object 'dbo.__MigrationLog'." when I try to do a import and generate script. I created the db from SQL Automations, compiled my two views and on...
Opps. My first migration scripts worked, to alter the tables. My second migration which just had updated views in it failed with a similar error, looks like it was trying to rerun all the old migration scripts against the altered table that no longer had the fieldname that was renamed? Here is my log: 2018-12-13T17:58:11.0912894Z
Validating Deployment Scripts...
2018-12-13T17:58:11.1347190Z
Ensuring Shadow database is up-to-date
2018-12-13T17:58:11.1413407Z
Building Shadow deployment script...
2018-12-13T17:58:11.4837798Z
Deploying Shadow database...
2018-12-13T17:58:20.2310016Z
##[error]TxSure
Solution\TxSureStaging\Migrations\0022_20180323-0633_thomas.philbrick.sql(0,0):
Error : An error occurred while attempting to verify project scripts:
Msg 207, Level 16,
State 1, Server TXSUREDEV-SQL01, Procedure ReadSubmitter, Line 29
Invalid column name
'ApplicationDate'. / comments
Opps. My first migration scripts worked, to alter the tables. My second migration which just had updated views in it failed with a similar error, looks like it was trying to rerun all the old mig...
Hello Andrea Angella, thank you, I rebuilt the shadow db per the article and was able to continue getting my updates up to TFS. Thanks! -Tom / comments
Hello Andrea Angella, thank you, I rebuilt the shadow db per the article and was able to continue getting my updates up to TFS. Thanks! -Tom
Actually the error occurs during "Script verification failed", says it failed against the shadow database. When I pulled the code back down from TFS, I had removed the main db and shadow db to initially build all from scratch. / comments
Actually the error occurs during "Script verification failed", says it failed against the shadow database. When I pulled the code back down from TFS, I had removed the main db and shadow db to ini...
Migration script fails due to column rename
Hello,My refresh is failing with a March 2018 migration script that is compiling against a table where I have renamed a column. 1. I cloned a new copy of all code down from source control.2. Ran a...
Super.
Any HTML to DOCX converters that will take all the objects that the tree view points at and export them? All the ones I try get stuck on the INDEX page so I get a 1 page doc? / comments
Super.
Any HTML to DOCX converters that will take all the objects that the tree view points at and export them? All the ones I try get stuck on the INDEX page so I get a 1 page doc?
Thanks Rob. Any plans coming up to allow the word doc to be formatted? We have a corporate style for all our docs and were hoping we could use that for our data dictionary. / comments
Thanks Rob. Any plans coming up to allow the word doc to be formatted? We have a corporate style for all our docs and were hoping we could use that for our data dictionary.