Activity overview
Latest activity by PeterG
Hi Astral, We updated the PowerShell today to help with some upcoming work on Sql Change Automation. And as you said you are able to pin to the older version if the new requirements don't work for you. Peter / comments
Hi Astral,We updated the PowerShell today to help with some upcoming work on Sql Change Automation. And as you said you are able to pin to the older version if the new requirements don't work for y...
Hi Dominick, We've just released the update, and to not take the upgrade if using a plugin you will need to pin the version of Sql Change Automation you pull down under the Sql Change Automation version configuration section to 3.1.18 [image] / comments
Hi Dominick,We've just released the update, and to not take the upgrade if using a plugin you will need to pin the version of Sql Change Automation you pull down under the Sql Change Automation ver...
Hi, That error has nothing to do with commit taking a while. Would be useful to know: - What SOC version are you on? - When is it slow? On refresh or on commit - What Version control you are connected to? - Is the database local? on site? or somewhere further away? - If using SVN or TFS? Are they on site or hosted remotely? The bottom two are often the cause of slowness, otherwise it would be useful to see the full logs. (Due to a bug they may appear in another Redgate tool's log file). If you don't want to attach the full logs here (very understandable) then you are best getting in touch via support@red-gate.com / comments
Hi,That error has nothing to do with commit taking a while. Would be useful to know:- What SOC version are you on?- When is it slow? On refresh or on commit- What Version control you are connected ...
Hi, Just wanted to let you know that we've just released an update to the SQL Change Automation Azure DevOps plugin (version 3.0.4) that adds support for SQL Doc when doing a build. You can find a checkbox in the configuration of the build step (under advanced if using sql source control project) that will automatically put the documentation in the created build artifact. [image] / comments
Hi,Just wanted to let you know that we've just released an update to the SQL Change Automation Azure DevOps plugin (version 3.0.4) that adds support for SQL Doc when doing a build. You can find a c...
Can you try running sqlcmd -S "(localdb)\mssqllocaldb"and if that fails you can try the fix in https://stackoverflow.com/a/44640176 / comments
Can you try runningsqlcmd -S "(localdb)\mssqllocaldb"and if that fails you can try the fix in https://stackoverflow.com/a/44640176
Hi, If you are using Redgate's SQL Source Control to manage your state then we already have static data supported - https://documentation.red-gate.com/soc6/common-tasks/link-static-data Or if you are using Redgate's SQL Change Automation in Visual Studio then you can also use static data - https://documentation.red-gate.com/sca3/developing-databases-using-sql-change-automation/generating-scripts-to-capture-database-changes/data-population/static-data If you are talking about the SSDT extension we were looking into then that did not get out of the research phase. / comments
Hi,If you are using Redgate's SQL Source Control to manage your state then we already have static data supported - https://documentation.red-gate.com/soc6/common-tasks/link-static-dataOr if you are...
Hi Jerome, As far as I can tell setting the option to false will create the temp table in the generated script. The option needs to be set before generating the script. When I did that I got a rebuild: [image] And the generated script was using a temporary table to copy the data with the correct column order. Note: You may need to close the project and reopen for the option change to be detected. Column order will NOT be taken care of at deployment. All deployment will do is run your checked in scripts in order. / comments
Hi Jerome,As far as I can tell setting the option to false will create the temp table in the generated script. The option needs to be set before generating the script. When I did that I got a rebui...
Probably means the instance is corrupt or something. You might want to recreate it using the command line: https://docs.microsoft.com/en-us/sql/relational-databases/express-localdb-instance-apis/command-line-management-tool-sqllocaldb-exe?view=sql-server-2017 sqllocaldb.exe stop ProjectsV13
sqllocaldb.exe delete ProjectsV13
sqllocaldb.exe create ProjectsV13<br>sqllocaldb.exe start ProjectsV13 This will force recreate the ProjectsV13 instance on localdb / comments
Probably means the instance is corrupt or something. You might want to recreate it using the command line: https://docs.microsoft.com/en-us/sql/relational-databases/express-localdb-instance-apis/co...
Hi Sai, There shouldn't be a problem with connecting to localdb, to help diagnose further could you contact support@red-gate.com with following information: Version you upgraded from: Version you upgraded to: 3.0.18291.2122 Visual Studio version: 15.8.7 SQLCmd version: And the logs from %LOCALAPPDATA%\Red Gate\Logs\SQL Change Automation\VS Also are you able to connect to (localdb)\ProjectsV13 from the visual studio server explorer? / comments
Hi Sai,There shouldn't be a problem with connecting to localdb, to help diagnose further could you contact support@red-gate.com with following information:Version you upgraded from: Version you upg...
Hi Sai, The error message you describe looks different from the logs you included. From what I can see ReadyRollA is failing to build due to a login connection issue. For help with that I would recommend emailing support@red-gate.com. As for the other two projects GlobalDB.SQLAutomation and MasterDB.SQLAutomation are failing to due to the build agent not being upgraded. From those logs it looks like you need to upgrade from ReadyRoll to Sql Change Automation on your build agents. / comments
Hi Sai,The error message you describe looks different from the logs you included.From what I can see ReadyRollA is failing to build due to a login connection issue. For help with that I would recom...