Comments
Sort by recent activity
The next version of SQL Source Control is being rebuilt from the ground up to support multiple databases and OSs. We're building this with high DPI in mind. A preview version for SQL Server is currently available. If you'd like to give it a try, you can download Flyway Desktop at https://download.red-gate.com/checkforupdates/FlywayDesktop. For help getting started, see https://documentation.red-gate.com/fd/flyway-desktop-using-sql-server-138346958.html. You should create a new project and then set up the connection to your development database. We're still working on the transition of existing SQL Source Control projects. Looking forward to hearing your feedback. If you'd like, you can schedule a 30 minute chat with me at https://calendly.com/stephanie-herr/30min-1?month=2021-12. / comments
The next version of SQL Source Control is being rebuilt from the ground up to support multiple databases and OSs. We're building this with high DPI in mind. A preview version for SQL Server is cu...
Hi Martin, I'm the Product Manager for Database DevOps. As Alex mentioned, we're currently looking into this to cover those cases you described and give teams more control over the deployment script, so that you do not have to go outside of the RG process. If you'd like to be part of our Early Access Program, please let me know (stephanie.herr @ red-gate.com). The only other way I've seen this done with the current capabilities in the Deployment Suite for Oracle is to use an idempotent Pre/Post script process that is orchestrated through your release management system. / comments
Hi Martin,I'm the Product Manager for Database DevOps. As Alex mentioned, we're currently looking into this to cover those cases you described and give teams more control over the deployment scrip...
There's more information on what Steve's talking about "AbortOnWarnings" at https://documentation.red-gate.com/sc13/using-the-command-line/switches-used-in-the-command-line. Data loss is a high warning. There's information about using SQL Compare options in SQL Change Automation at https://documentation.red-gate.com/sca3/automating-database-changes/automated-deployments/using-sql-compare-options-with-sql-change-automation-powershell-module. You can also put option parameters in the SQL Change Automation Build/Release extensions (TFS/VSTS/Octopus Deploy). / comments
There's more information on what Steve's talking about "AbortOnWarnings" at https://documentation.red-gate.com/sc13/using-the-command-line/switches-used-in-the-command-line. Data loss is a high wa...
It's been pulled due to an unrelated issue. We're working on getting a new version out as soon as possible. I'll let you know. Thanks for trying this and sorry about the inconvenience. / comments
It's been pulled due to an unrelated issue. We're working on getting a new version out as soon as possible. I'll let you know. Thanks for trying this and sorry about the inconvenience.
It's back up now. Thanks for your patience and for trying this, Alex. SQL Source Control v6.3 - https://documentation.red-gate.com/soc6/release-notes-and-other-versions/sql-source-control-6-3-release-notes. Remember to configure Frequent Updates in SQL Source Control > Help and then Check for Updates in SQL Source Control > Help. / comments
It's back up now. Thanks for your patience and for trying this, Alex.SQL Source Control v6.3 - https://documentation.red-gate.com/soc6/release-notes-and-other-versions/sql-source-control-6-3-relea...
SQL Change Automation integrates with existing build and release systems. It's not a replacement for them and it is not a version control system. So, SQL Change Automation may not help with this. I'll send you a message and maybe we could have a quick call so I can understand what you're doing better. Thanks! / comments
SQL Change Automation integrates with existing build and release systems. It's not a replacement for them and it is not a version control system. So, SQL Change Automation may not help with this....
There's a webinar about Database DevOps using ReadyRoll and the new VSTS extension (which also works with TFS) for CI/CD tomorrow Tues Nov 28th at noon ET - https://attendee.gotowebinar.com/register/817288270091583491?source=FORG. / comments
There's a webinar about Database DevOps using ReadyRoll and the new VSTS extension (which also works with TFS) for CI/CD tomorrow Tues Nov 28th at noon ET - https://attendee.gotowebinar.com/registe...
I had a similar issue.
It was looking for sqlCI.exe in C:Program Files (x86)Red Gate. I had to copy and paste this folder from C:Program Files (x86)Red GateSQL Automation Pack 1, which seemed to work. Maybe there's a better way to solve this? / comments
I had a similar issue.
It was looking for sqlCI.exe in C:Program Files (x86)Red Gate. I had to copy and paste this folder from C:Program Files (x86)Red GateSQL Automation Pack 1, which seemed to w...
Hi Joseph,
We should have a command line that will do what you need within the next week or 2. This will pick up migration scripts and also do a SQL Compare of the source and target to either generate a deployment script or synch the target directly. Just like SQL Compare will do.
It's separate for now while we integrate Migrations v2 into the SQL Compare GUI. Once this integration is done, then we'll have a release of SQL Compare with the updated command line to pick up the new migrations.
So, you can use this alternative command line to do automated deployments (esp. in CI environments) until SQL Compare is ready. It will have the same licensing requirements as SQL Compare.
I hope this helps! We'd love to hear how you get on with the SQL Source Control Early Access Release and this migration command line tool. / comments
Hi Joseph,
We should have a command line that will do what you need within the next week or 2. This will pick up migration scripts and also do a SQL Compare of the source and target to either gene...
Hi Joseph,
Thanks for clarifying. In Migrations v2, a migration script doesn't have to be tied to DDL changes. So, you can just write your UPDATE script as a migration script and this will be picked up like all the other migrations. To do this, use the "Add migration script..." button on the Migrations tab. / comments
Hi Joseph,
Thanks for clarifying. In Migrations v2, a migration script doesn't have to be tied to DDL changes. So, you can just write your UPDATE script as a migration script and this will be pic...