Comments
Sort by recent activity
This looks like a bug. I am using SSMS v17 and SQL Source Control 6.1.8.7584 (not the latest) and it works for me. By finding "case" it only shows a single result that is "Use case-sensitive object definition". Can you see the full list of options if you don't provide a search text? What versions of SSMS and SQL Source Control are you using? / comments
This looks like a bug.I am using SSMS v17 and SQL Source Control 6.1.8.7584 (not the latest) and it works for me. By finding "case" it only shows a single result that is "Use case-sensitive object ...
Yes, there is. The documentation is on its way! The new plugin is shipped and usable if you want to give it a try. You can download it at this address: https://www.red-gate.com/dlmas/TeamCity-download / comments
Yes, there is. The documentation is on its way! The new plugin is shipped and usable if you want to give it a try.You can download it at this address: https://www.red-gate.com/dlmas/TeamCity-download
Hi @GordonMPG, you can find documentation on how to use the TeamCity plugin with SQL Change Automation projects at the following address https://documentation.red-gate.com/sca3/automating-database-changes/add-ons/teamcity/use-the-teamcity-plugin-with-a-sql-change-automation-project If you intend to use the TeamCity plugin with SQL Source Control projects look at this documentation instead https://documentation.red-gate.com/sca3/automating-database-changes/add-ons/teamcity/use-the-teamcity-plugin-with-a-sql-source-control-project / comments
Hi @GordonMPG, you can find documentation on how to use the TeamCity plugin with SQL Change Automation projects at the following address https://documentation.red-gate.com/sca3/automating-database-...
Have you managed to solve your issue? We released a new updated version of the step templates at the end of last week that might work for you. This is the latest published documentation on how to setup SQL Change Automation with Octopus: https://documentation.red-gate.com/sca3/automating-database-changes/add-ons/octopus-deploy/use-the-sql-change-automation-step-templates If you have any issue, please don't hesitate to contact our support team and we can have a more in-depth look at your issue. Thanks for using SQL Change Automation! / comments
Have you managed to solve your issue?We released a new updated version of the step templates at the end of last week that might work for you.This is the latest published documentation on how to set...
The new release of the step templates is now available. This is the latest published documentation on how to setup SQL Change Automation with Octopus: https://documentation.red-gate.com/sca3/automating-database-changes/add-ons/octopus-deploy/use-the-sql-change-automation-step-templates If you have any issue, please don't hesitate to contact our support team. / comments
The new release of the step templates is now available.This is the latest published documentation on how to setup SQL Change Automation with Octopus: https://documentation.red-gate.com/sca3/automat...
Which version of SQL Source Control are you using? I tested it with the latest version 6.3 and it works. Make sure you restart SSMS after adding the <WorkingPath> inside the RedGate_SQLSourceControl_Engine_EngineOptions.xml file and unlink and relink your database. / comments
Which version of SQL Source Control are you using?I tested it with the latest version 6.3 and it works.Make sure you restart SSMS after adding the <WorkingPath> inside the RedGate_SQLSourceControl_...
I am not sure I understand your scenario properly to give you an informed answer. If you need to insert more details I recommend you contact support via email for more guidance so we can better assist you. Are the databases different for each customer or they share the same schema? If you are looking into adoptioning continuous integration, have a look at SQL Change Automation and our documentation in the Add-Ons section. We have a tutorial that explains how to set up a build/release pipeline using the most common tools like VSTS, TeamCity, Octopus and so on. You can easily add build/release support to your SQL Source Control projects using SQL Change Automation Add-Ons or PowerShell. https://documentation.red-gate.com/sca3/automating-database-changes/add-ons If you deal with big databases and you need to copy them for local development (rather than making changes directly in production) SQL Clone might help with that https://www.red-gate.com/products/dba/sql-clone/ / comments
I am not sure I understand your scenario properly to give you an informed answer. If you need to insert more details I recommend you contact support via email for more guidance so we can better ass...
When the script runs, it's trying to automatically download the DLMAutomation module from the PowerShell gallery https://www.powershellgallery.com/packages/DLMAutomation/2.1.3.2175 If it can't download the module from the gallery, it tries to see if you installed DLM using one of our installers and use the module from the installation directory. The module contains all the cmdlets needed by the VSTS plugin to execute the database build and release. Make sure you have access to the Internet so that the script can correctly download the module from the PS gallery or manually install DLM on your agent. Alternatively, you can manually install the module using the Install-Module cmdlet. However, I recommend you to use version 3 of the VSTS plugins now called SQL Change Automation that is using the latest version of the module from the PS Gallery. The older DLMAutomation module is no longer maintained. This is the link to the new module https://www.powershellgallery.com/packages/SqlChangeAutomation/3.1.3.3059 This screenshot shows how you can upgrade to version 3 [image] You no longer need to install SQL Change Automation on your agents. The VSTS plugins should automatically download the latest SqlChangeAutomation module from the gallery. After the upgrade, all your pipelines should continue to work as before. In specific scenarios, you might need to make some minor adjustments. If you need any help, just ask in the forum or contact support at support@red-gate.com / comments
When the script runs, it's trying to automatically download the DLMAutomation module from the PowerShell gallery https://www.powershellgallery.com/packages/DLMAutomation/2.1.3.2175If it can't downl...
The time varies greatly based on a number of factors like the number of objects in your database, how much static data you added and how many occasional migrations you have. Unfortunately, it's not totally uncommon to have commits taking minutes as there is quite a lot of work happening under the covers. If you want to provide more information about your schema, I invite you to contact support. Out of curiosity, for more information on how SQL Source Control works under the cover have a look at this document https://documentation.red-gate.com/soc6/reference-information/how-sql-source-control-works-behind-the-scenes / comments
The time varies greatly based on a number of factors like the number of objects in your database, how much static data you added and how many occasional migrations you have. Unfortunately, it's not...
You can find step by step instructions on how to setup VSTS / TFS pipelines with SQL Source Control projects at the following addresses:
Use the VSTS Build extension with SQL Source Control Project
Use the VSTS Release extension with an approval step
Hope this helps. / comments
You can find step by step instructions on how to setup VSTS / TFS pipelines with SQL Source Control projects at the following addresses:
Use the VSTS Build extension with SQL Source Control Projec...