Comments
Sort by recent activity
Perfect, Thanks! / comments
Perfect, Thanks!
I am thinking in order to create the documentation and save it to disk a new powershell cmdlet needs to be created, Export-DataDocumentation? If so is there a user voice some place for SCA I could request this? Not seeing one like your other products have. Also SCA does not have a road map that I can find like other products have, is there a road map? Co-worker was thinking this may be a dead product because it does not have these like your other tools do. Thanks / comments
I am thinking in order to create the documentation and save it to disk a new powershell cmdlet needs to be created, Export-DataDocumentation? If so is there a user voice some place for SCA I could...
Actually I am just now going down the path of using the powershell cmdlets. looks like it is set in the New-DatabaseReleaseArtifact -SqlCmdVariables switch. Example:
$SqlCmdVariables = @{ReleaseVersion = $IterationNumber;}
$DBConnection = New-DatabaseConnection -ServerInstance $EAMDBServer -Database $PQDBName
$DBUpdate = New-DatabaseReleaseArtifact -Source $DBDeployFile -Target $DBConnection -SqlCmdVariables $SqlCmdVariables
Use-DatabaseReleaseArtifact $DBUpdate -DeployTo $DBConnection
/ comments
Actually I am just now going down the path of using the powershell cmdlets. looks like it is set in the New-DatabaseReleaseArtifact -SqlCmdVariables switch. Example:
$SqlCmdVariables = @{ReleaseV...
Not sure if this helps as I am not using Bamboo, just using a powershell script with the deployment file produced from the build at this time. See this doco under: Deploying from PowerShell https://documentation.red-gate.com/sca3/automating-database-changes/automated-deployment-with-sql-change-automation-core/sqlcmd-package-deployment Just set the $ReleaseVersion variable, Example: & { $DatabaseServer = $EAMDBServer; $ReleaseVersion = $IterationNumber; &$DBDeployFile }
/ comments
Not sure if this helps as I am not using Bamboo, just using a powershell script with the deployment file produced from the build at this time.See this doco under: Deploying from PowerShellhttps://d...
I have learned a couple of things to answer this myself for anyone else who may see this. 1. if you accidentally post a question flagged as a discussion it won't get an answer. 2. The slowness was only on my laptop. Running the script on the deployment server was fast. What I was experiencing is not normal. Not sure what was affecting the speed but I would guess some security tool was blocking / slowing actions. / comments
I have learned a couple of things to answer this myself for anyone else who may see this.1. if you accidentally post a question flagged as a discussion it won't get an answer.2. The slowness was on...
The Programmable Object file was automatically generated by the tool. If I manually change it, will my changes get overwritten at some point by the tool again? / comments
The Programmable Object file was automatically generated by the tool. If I manually change it, will my changes get overwritten at some point by the tool again?
Thanks, the part I was missing was how to manually add a migration script. I think this is the direction I should take. After doing this though and clicking refresh I get a failed to verify against shadow database error. The error is on the Programmable Objects not the new migration script I just created. I deployed the migration script with the button in visual studio. How do I fix this? ***** EXECUTING MIGRATION "Programmable Objects\dbo\Functions\Return_RM_ID.sql", ID: {f5c49548-a0de-5be0-be35-18ab932660b4} ***** Msg 3729, Level 16, State 1, Server xxxxx\xxxxx, Line 2 Cannot DROP FUNCTION 'dbo.Return_RM_ID' because it is being referenced by object 'CHK_RM_ID'. / comments
Thanks, the part I was missing was how to manually add a migration script. I think this is the direction I should take. After doing this though and clicking refresh I get a failed to verify against...
I would have to say that the issue for the 'Import and generate script' button is not fixed with the above post. I am running the latest version and when the button is clicked the end user has no idea that anything is actually happening. It takes about 30 secs but during that time I can click it again and again. From a UI design standpoint the button should be grayed out when clicked and some kind of spinner should be displayed so the user knows something is happening. As a new user I was really thrown off by this behavior. Now I know its just some jank in the tool and I know to just wait, but you really should fix this. / comments
I would have to say that the issue for the 'Import and generate script' button is not fixed with the above post. I am running the latest version and when the button is clicked the end user has no ...
Is anyone else having this issue? I attached a zipped mp4 of what it looks like when it happens. I just updated in visual studio and it still happens. / comments
Is anyone else having this issue? I attached a zipped mp4 of what it looks like when it happens. I just updated in visual studio and it still happens.
Log files sent / comments
Log files sent