Comments
Sort by recent activity
Hi @butlerpaul Unfortunately, we have no current plans to support SQLCMD Go within SQL Change Automation I would advise posting the idea here: https://redgate.uservoice.com/forums/267000-sql-change-automation / comments
Hi @butlerpaulUnfortunately, we have no current plans to support SQLCMD Go within SQL Change AutomationI would advise posting the idea here: https://redgate.uservoice.com/forums/267000-sql-change-a...
Hi @JeCzerno Thanks for providing that info! In this case, I would need a schema only copy of the database to troubleshoot this further. I'm going to reach out via a support ticket to have a look into this. / comments
Hi @JeCzerno Thanks for providing that info!In this case, I would need a schema only copy of the database to troubleshoot this further.I'm going to reach out via a support ticket to have a look int...
Hi @JeCzerno Could you provide a screenshot of the error you're seeing, please? / comments
Hi @JeCzerno Could you provide a screenshot of the error you're seeing, please?
Hi @Obiero That's odd, to isolate the issue, could you try creating a local flyway project with the database you're trying to clean as the target and then do a flyway clean command and see if you get an error? / comments
Hi @Obiero That's odd, to isolate the issue, could you try creating a local flyway project with the database you're trying to clean as the target and then do a flyway clean command and see if you g...
Hi @Obiero Thank you for pointing out that error in one of my screenshots, I'll update that now! databaseName should be the name of your production database! Here's what it should look like: [image] [image] / comments
Hi @ObieroThank you for pointing out that error in one of my screenshots, I'll update that now!databaseName should be the name of your production database!Here's what it should look like:
Hi Obiero I've come across this behaviour myself, and it's down to the value you're putting for schemas in your vars yaml I made an updated guide for creating a pipeline with SQL server with YAML which addresses these new changes - https://redgatesupport.zendesk.com/knowledge/editor/01HSZSGR4HQD2D8WTF8G973BD9/en-us?brand_id=3280206[image] / comments
Hi ObieroI've come across this behaviour myself, and it's down to the value you're putting for schemas in your vars yamlI made an updated guide for creating a pipeline with SQL server with YAML whi...
Hi @BNitsche Unfortunately, it's not possible to automate these steps using the Flyway CLI / comments
Hi @BNitscheUnfortunately, it's not possible to automate these steps using the Flyway CLI
Hi @cgott42 If you were using SQL Source Control to track your schema changes, you could select a specific revision for comparison to achieve this SQL Compare, doesn't natively allow you to set a specific comparison window and will just compare everything For the second question, you can save the schema to a scripts' folder for comparing at a later date / comments
Hi @cgott42 If you were using SQL Source Control to track your schema changes, you could select a specific revision for comparison to achieve thisSQL Compare, doesn't natively allow you to set a sp...
Hi @Yukesh_Sekar29 The baseline will only be deployed to a target database if it's empty. In rare cases, if you've modified the schema history table and there's no entry for the baseline, it will also be deployed. / comments
Hi @Yukesh_Sekar29 The baseline will only be deployed to a target database if it's empty.In rare cases, if you've modified the schema history table and there's no entry for the baseline, it will al...
Hi @NeedForSpid Ah, thank you for clarifying! Unfortunately, there's no mechanism for disabling the window within the tool / comments
Hi @NeedForSpid Ah, thank you for clarifying!Unfortunately, there's no mechanism for disabling the window within the tool