User profile for Andrew P

Hey Eric, Thanks for contacting us and sorry you are having this issue! This is just a copy of what I sent via email- Would you mind updating to the latest version of Source Control? (Help -> Check for Updates, see attached) If that does not work could you close SSMS then go to C:Users%UserName%AppDataLocalRed GateSQL Source Control 5Caches and delete the contents? Let me know if you continue to get any errors after that! Warmly, / comments

Hey Eric, Thanks for contacting us and sorry you are having this issue! This is just a copy of what I sent via email- Would you mind updating to the latest version of Source Control? (Help -> Check...

0 votes

Thanks for contacting us and sorry you are having this issue! If you created objects named dbo.f_nameoffunctionV2, dbo.f_nameoffunctionV21, dbo.f_nameoffunctionV22, dbo.f_nameoffunctionV23 etc on the database It sounds like it would create an object for each of those - so each commit would not replace/edit the object, but create a new object alongside it. I am not sure why there would be a duplicate object, unless someone manually put one in the repository without changing the object name in the Create script- Source Control will not allow you to commit an object with a duplicate Create script and neither will SQL Server. Did your colleague manually put/edited those scripts in the Source Control repository? Thanks for your help! / comments

Thanks for contacting us and sorry you are having this issue! If you created objects named dbo.f_nameoffunctionV2, dbo.f_nameoffunctionV21, dbo.f_nameoffunctionV22, dbo.f_nameoffunctionV23 etc on t...

0 votes

Hey Eric, Thanks for contacting us and sorry you are having this issue! This is just a copy of what I sent via email- Would you mind updating to the latest version of Source Control? (Help -> Check for Updates, see attached) If that does not work could you close SSMS then go to C:Users%UserName%AppDataLocalRed GateSQL Source Control 5Caches and delete the contents? Let me know if you continue to get any errors after that! Warmly, / comments

Hey Eric, Thanks for contacting us and sorry you are having this issue! This is just a copy of what I sent via email- Would you mind updating to the latest version of Source Control? (Help -> Check...

0 votes

Thanks for contacting us! I would recommend generating the deployment scripts using SQL Data Compare- the edit the script with a find/replace tool in SSMS, Notepad, etc. You can also filter the comparison using the Where clause editor https://documentation.red-gate.com/disp ... ERE+clause If neither of those work then this might be a good feature request for our Uservoice forum https://redgate.uservoice.com/forums/14 ... ta-compare Kind Regards, / comments

Thanks for contacting us! I would recommend generating the deployment scripts using SQL Data Compare- the edit the script with a find/replace tool in SSMS, Notepad, etc. You can also filter the com...

0 votes

Hey Warren, Thanks for your post and I apologize for the late reply! Note this is just a recap of what I sent via email. You can choose the option "Don't use transactions in Deployment scripts" in both Compare and Source Control. More info here https://documentation.red-gate.com/disp ... on+options That should solve this particular issue. Warm Regards, / comments

Hey Warren, Thanks for your post and I apologize for the late reply! Note this is just a recap of what I sent via email. You can choose the option "Don't use transactions in Deployment scripts" in ...

0 votes

Hey boaldave, Thanks for your post! I highly suggest you post your idea to our UserVoice forum where other devs can vote or comment on the idea https://redgate.uservoice.com/forums/39 ... ce-control The devs regularly take the best ideas from the forum and implement them. I will follow up with you via email in case you have further questions. Kind Regards, / comments

Hey boaldave, Thanks for your post! I highly suggest you post your idea to our UserVoice forum where other devs can vote or comment on the idea https://redgate.uservoice.com/forums/39 ... ce-contro...

0 votes

Hey Csuire, Thanks for contacting us! You can save it as part of a project file (the "On Error:" setting will be preserved in there) so it sounds like you would like the ability to set a default "On Error:" value. I have submitted this to the project managers as Feature Request SE-698 and it will be reviewed and triaged. I will also reach out to you via email in case you have any further questions or issues! Kind Regards, / comments

Hey Csuire, Thanks for contacting us! You can save it as part of a project file (the "On Error:" setting will be preserved in there) so it sounds like you would like the ability to set a default "O...

0 votes

Hey Csuire, Thanks for contacting us! I have submitted this to the project managers as feature request SE-699. Please let me know if you have any further questions or issues! Warmly, / comments

Hey Csuire, Thanks for contacting us! I have submitted this to the project managers as feature request SE-699. Please let me know if you have any further questions or issues! Warmly,

0 votes

Hey JPotter, Thanks for contacting us! It sounds like you would like to Merge the records between these two tables- as you have noticed, when a comparison is done, it compares based on comparison keys (usually indexes, PKs and FKs) and finds which keys are missing from the Source, missing from the Target, or occurring in both but with different values. (more info on the comparison results here https://documentation.red-gate.com/disp ... on+results) However you can manually set the comparison keys- so that instead of basing the comparison on indexes or FKs that may match but have different data, you can compare the data- say the comparison key is Eye Color so that it compares based on that rather than something meaningless and wrong (in this instance) like the FK. (see the "Selecting the comparison key" section in here https://documentation.red-gate.com/disp ... +and+views ) Once you are comparing based on data that is not arbitrarily different, you can get a better idea of what you need to merge. You can generate Insert Scripts for a merged table by deploying the Source Only data from each database (so compare once, generate the deployment script for the Source Only data, then switch the Source and the Target and generate the deployment script for the Source Only data). So this would give you all of the Insert scripts for the merged db- but you still need the schema right? You would need to create a database with the desired structure- SQL Data Compare only does data, so SQL Compare may help you deploy the objects that you desire or you may need to manually generate/modify the structure- you would then apply the generated Insert scripts to the new db. This requires some manual stitching but it may be possible depending on how different your new database needs to be. I will also follow up with you via email in case you have any questions or issues with the above! Kindly, / comments

Hey JPotter, Thanks for contacting us! It sounds like you would like to Merge the records between these two tables- as you have noticed, when a comparison is done, it compares based on comparison k...

0 votes

Hey MKZeke, Thanks for your post! Compare command line does not support -whatif and -confirm commands- those commands are part of the Powershell cmdlet framework and Compare was not made using the framework. That would probably be a useful thing to implement in the future, and you can request it here https://redgate.uservoice.com/forums/141379-sql-compare Kindly, / comments

Hey MKZeke, Thanks for your post! Compare command line does not support -whatif and -confirm commands- those commands are part of the Powershell cmdlet framework and Compare was not made using the ...

0 votes

How can we help you today?

Andrew P

Comments