Comments
Sort by recent activity
Hi @yantis, Your question seems similar to the one below. https://forum.red-gate.com/discussion/79770/auto-scheduled-commits / comments
Hi @yantis,Your question seems similar to the one below.https://forum.red-gate.com/discussion/79770/auto-scheduled-commits
Hi @gemu, If you want to undo a change that you have not commited yet you should be able to do it by right-clicking the object on the Commit tab. If you want to rollback an object to a previous version you should use the View History functionality. / comments
Hi @gemu,If you want to undo a change that you have not commited yet you should be able to do it by right-clicking the object on the Commit tab.If you want to rollback an object to a previous versi...
Hi @Monday I think the way we handle Programmable is dropping and recreating them so there's no alternative. / comments
Hi @Monday I think the way we handle Programmable is dropping and recreating them so there's no alternative.
The scripts that SQL Change Automation holds in the Offline Schema Model folder should be compatible but the ones in the Programmable Objects folder wouldn't be compatible because they also have DROP statements at the beginning. A bit more information in our documentation https://documentation.red-gate.com/display/SCA3/Programmable+Objects https://documentation.red-gate.com/display/SCA3/Offline+Schema+Model / comments
The scripts that SQL Change Automation holds in the Offline Schema Model folder should be compatible but the ones in the Programmable Objects folder wouldn't be compatible because they also have DR...
Hi @JMcKinnon Unfortunately, we don't have a way to support migrating the commit history from SQL Source Control to SQL Change Automation. / comments
Hi @JMcKinnon Unfortunately, we don't have a way to support migrating the commit history from SQL Source Control to SQL Change Automation.
Hi @... I'm afraid this is probably just related to the size of your database. If you have a lot of objects it may have an impact on performance. / comments
Hi @... I'm afraid this is probably just related to the size of your database. If you have a lot of objects it may have an impact on performance.
Which versions of Visual Studio and SSDT are you using? Could you please try to update them? / comments
Which versions of Visual Studio and SSDT are you using? Could you please try to update them?
This won't cause any issues with you deployment using SQL Change Automation. This should be addressed by installing PowerShell Get 2 on the tentacle. You can do this by running the following as an admin in PowerShell on the tentacle Update-Module -Name PowerShellGet More info: The problem occurs because you have PowerShell Get 1.0.0.1 on the machine, and we require at least 1.6. So we install that but due to an issue in PowerShell Get, you get the warning when we install version 2 of the module. / comments
This won't cause any issues with you deployment using SQL Change Automation.This should be addressed by installing PowerShell Get 2 on the tentacle.You can do this by running the following as an ad...
I don't think there's much you can do to speed it. May be it's just taking a bit of time to compare your the build artifact against your production database if you're dealing with a large database. / comments
I don't think there's much you can do to speed it. May be it's just taking a bit of time to compare your the build artifact against your production database if you're dealing with a large database.
I'm sorry @Nirmal_Raisoni but I don't think I've fully understood it yet. Yes, the package contains new objects, removed objects and modified objects which is what you would need to do a database deployment in order to update it. Are you after a script that only has new objects in it and ignores modified and removed objects? If it's that I don't think there is a way to get it at the moment. What would that allow you to do? / comments
I'm sorry @Nirmal_Raisoni but I don't think I've fully understood it yet. Yes, the package contains new objects, removed objects and modified objects which is what you would need to do a database d...