Activity overview
Latest activity by GordonMPG
Team City - SQL Change Automation (Build database)
I have a SQL database project with tables and stored procs. We also have a Post Deployment script folder. But in this Post Deployment script folder we have scripts that developers use locally. Thes...
@Andrea_Angella thanks for the info, it was very helpful! / comments
@Andrea_Angella thanks for the info, it was very helpful!
Team City Plugin update for SQL Change automation
Is there an updated plugin for SQL Change automation? If not how can I access the older plugin for DLM Automation, is that expected to work? I reviewed the documentation at https://documentation.re...
Octopus Deploy - Step Templates
We upgraded to SQL Change Automation and having problems with our step templates.I looked at the step template and it's still referencing DLM automation, am I using an outdated step template or has...
Fixed by creating a custom step template and using:
New-OctopusArtifact "$exportPath\Reports\Changes.html" -Name "$DLMAutomationDatabaseName-Changes.html"
New-OctopusArtifact "$exportPath\Reports\Warnings.xml" -Name "$DLMAutomationDatabaseName-Warnings.xml"
New-OctopusArtifact "$exportPath\Update.sql" -Name "$DLMAutomationDatabaseName-Update.sql" / comments
Fixed by creating a custom step template and using:
New-OctopusArtifact "$exportPath\Reports\Changes.html" -Name "$DLMAutomationDatabaseName-Changes.html"
New-OctopusArtifact "$exportPath\Reports\W...
DLM Automation - Seed Data
Hello,
I have a visual studio database project, there is a post deployment script in:
~/Database/Scripts/Post Deployment
I am trying to get this script to run to populate my tables. I am using Team...
Octopus Deploy - Custom file name for change script and change report
Hello,
Is there anyway to apply a custom name to the change script (Changes.sql) and change report (Changes.html). In octopus deploy we are generating multiple change scripts because we have multip...
Rob,
I have another error, let me know if I should create a new post please?
[16:30:42][Step 1/2] "Latin1_General_CI_AS" in the equal to operation.
[16:30:42][Step 1/2] Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to
[16:30:42][Step 1/2] operation.' occurred when executing the following SQL:
I searched the code and there is no place where Latin1_General_CI_AS is set. The default on the database is "SQL_Latin1_General_CP1_CI_AS"
Any idea on how to fix this?
If I were to publish to a brand new database via Visual Studio it publishes fine.
Thank you!
UPDATE: I was able to get passed the error using the IgnoreCollations SQL Compare option / comments
Rob,
I have another error, let me know if I should create a new post please?
[16:30:42][Step 1/2] "Latin1_General_CI_AS" in the equal to operation.
[16:30:42][Step 1/2] Cannot resolve the collation...
Hello Robert,
This works! Thank you. / comments
Hello Robert,
This works! Thank you.
DLM Build Error
Hello,
I am using the Team City DLM build plugin to create a build script. It seems there is some errors with the change script that the tool is trying to publish to the temp database. The error is...