Comments
Sort by recent activity
Hi @Louis_Gigantisch unfortunately this isn't a feature within SQL Source Control, if however you'd like to make a suggestion this can be made here - https://redgate.uservoice.com/forums/39019-sql-source-control Alternatively, if I'm understanding the scenario correctly you can use SQL Compare to compare the branch from Source Control to the live database and generate a deployment script that way. Hope this helps! / comments
Hi @Louis_Gigantisch unfortunately this isn't a feature within SQL Source Control, if however you'd like to make a suggestion this can be made here - https://redgate.uservoice.com/forums/39019-sql-...
Hi @svallarian unfortunately SQL Compare isn't a deployment tool and can only deploy changes directly onto a live database or generate a script to be run against it. I would suggest taking a look at SQL Change Automation for your needs. / comments
Hi @svallarian unfortunately SQL Compare isn't a deployment tool and can only deploy changes directly onto a live database or generate a script to be run against it. I would suggest taking a look a...
Hi @OmerDogus I suspect the SavedTabs file may have been reset, however you may be able to restore it. If you go to %localappdata% > Red Gate > SQL Prompt 10 and copy the SavedTabs file and paste it into the SQL Prompt 9 folder. / comments
Hi @OmerDogus I suspect the SavedTabs file may have been reset, however you may be able to restore it. If you go to %localappdata% > Red Gate > SQL Prompt 10 and copy the SavedTabs file and paste i...
Hi @MichaelFurey I believe what you're referring to is when a particular object in the source database doesn't exist in the target database and when you deploy it, it "deletes it" from the target. Overall glad you managed to resolve your scenario with your approach! / comments
Hi @MichaelFurey I believe what you're referring to is when a particular object in the source database doesn't exist in the target database and when you deploy it, it "deletes it" from the target. ...
Hi MichaelFurey unfortunately it's not possible to delete objects using SQL Compare. However I recommend the following steps to recreate your scenario in a cleaner manner!
Create an empty database as your target
Compare your "big" database to your newly created "modified big database" empty database
Select all the objects you wish to keep from your original big database to your newly created big modified database and deploy
You can then use SQL Data Compare to deploy the data cross into your new database schema
/ comments
Hi MichaelFurey unfortunately it's not possible to delete objects using SQL Compare. However I recommend the following steps to recreate your scenario in a cleaner manner!
Create an empty database ...
Hi @Melinda to do this you can select the same database as the source & target to compare. Make sure the two tables are mapped, if they're different you can setup custom mapping. / comments
Hi @Melinda to do this you can select the same database as the source & target to compare. Make sure the two tables are mapped, if they're different you can setup custom mapping.
Hi @RichardRay Not a worry! when a forum post comes in a ticket is automatically generated, i'll follow this up within the ticket and we can continue from there! / comments
Hi @RichardRay Not a worry! when a forum post comes in a ticket is automatically generated, i'll follow this up within the ticket and we can continue from there!
Hi @RichardRay Could you please ensure that the account given to the SQL Backup Agent has permissions to the COPYTO share. Could you please send over the log files, if you're not able to send them across the forum, I can reach out to you through a ticket. Please let me know how you would like to proceed / comments
Hi @RichardRay Could you please ensure that the account given to the SQL Backup Agent has permissions to the COPYTO share. Could you please send over the log files, if you're not able to send them ...
Hi @Shaheer Could you please provide an example of what you mean by this? I've created two deployment scripts using both the UI and CLI with SQL Data Compare and they're using the INSERT form. / comments
Hi @Shaheer Could you please provide an example of what you mean by this? I've created two deployment scripts using both the UI and CLI with SQL Data Compare and they're using the INSERT form.
Hi @HerrDVD @mattbenham apologies I can confirm this bug seems to have returned, I'm raising this with the developers now to get a fix / comments
Hi @HerrDVD @mattbenham apologies I can confirm this bug seems to have returned, I'm raising this with the developers now to get a fix