How can we help you today? How can we help you today?
Andrew P
Activity overview Badges (0) Posts (0) Comments (187)

Comments

Sort by recent activity
Hey Adam, Thanks for posting! I have followed up with you via email for further troubleshooting. Kind Regards, / comments
  1. Community
  2. SQL Compare 11
  3. View not refreshed after table change
Hey Adam, Thanks for posting! I have followed up with you via email for further troubleshooting. Kind Regards,
0 votes
Hey Teknik, Thanks for posting! I have followed up with you via email for further details but for anyone reading this- this sometimes occurs on only one or two objects. If you can narrow down the objects by viewing the preview on individual object that helps. Additionally we always recommend that you send in the error report with the email address attached. I look forward to working with you further! Kind Regards, / comments
  1. Community
  2. SQL Doc
  3. Error Table generate ?
Hey Teknik, Thanks for posting! I have followed up with you via email for further details but for anyone reading this- this sometimes occurs on only one or two objects. If you can narrow down the o...
0 votes
Thanks for posting! Currently SQL Data Generator cannot generate into anything other than a SQL Server database- and there is currently no way for it to use an XSD to define the schema. If you could elaborate on why this would be useful I can submit a feature request for this. I have also contacted you via email for further followup. Best, / comments
  1. Community
  2. SQL Data Generator
  3. XML Generation (with data integrity)
Thanks for posting! Currently SQL Data Generator cannot generate into anything other than a SQL Server database- and there is currently no way for it to use an XSD to define the schema. If you coul...
0 votes
Hey rivrluvr, Thanks for contacting us and sorry you are having this issue! I have contacted you via email to get some more insight on this issue. Warm Regards, / comments
  1. Community
  2. SQL Search
  3. SQL Search fails to connect to connected server in SSMS
Hey rivrluvr, Thanks for contacting us and sorry you are having this issue! I have contacted you via email to get some more insight on this issue. Warm Regards,
0 votes
Hello, Thanks for your query- this is just a copy paste of what I sent via email. There is no way to do that programmatically, so you would have to manually set the mapping for each set of Sources and Targets. Once you set the mapping- you can save it in a project file allowing you to reuse it either in the GUI or command line- so you would never have to map it again. You can always manually edit the scripts that SQL Compare outputs and that will allow you to make even more changes to how you want it deployed. More info on mapping https://documentation.red-gate.com/disp ... nd+columns More info on projects https://documentation.red-gate.com/disp ... h+projects If there is something else that you do not see available in the tool- I suggest you post the idea in our UserVoice forum available here https://redgate.uservoice.com/forums/141379-sql-compare Hope you have a great weekend! Warm Regards, / comments
  1. Community
  2. SQL Compare 11
  3. Mappings
Hello, Thanks for your query- this is just a copy paste of what I sent via email. There is no way to do that programmatically, so you would have to manually set the mapping for each set of Sources ...
0 votes
Hey ppat, Thanks for contacting us and this is an interesting issue! I don't know if this is possible in your scenario, but using the DLM Automation Suite with SQL CI/Team City for the automated build-test-package steps and SQL Release/Octopus Deploy for the automated package extraction and deployment seems to work really well for many of our customers. If you did not want to do that then you could do what you described, the migrations you describe seem very feasible and I might add that you could package up the deployment scripts using SQL Packager then move the package to your client's machine and deploy it. More documentation on that https://documentation.red-gate.com/disp ... +a+package Please let me know if that helps! Warmly, / comments
  1. Community
  2. SQL Compare 11
  3. Self supporting remote client updating?
Hey ppat, Thanks for contacting us and this is an interesting issue! I don't know if this is possible in your scenario, but using the DLM Automation Suite with SQL CI/Team City for the automated bu...
0 votes
Thanks for reporting that Warren, Our team has definitely become aware of this recently- we are currently working on compatibility issues with future versions of SSMS. Currently we do not officially support anything after SSMS 2014- however you should not have any issues with SSMS 2016 CTP3. I would recommend you wait until SSMS 2016 is out of beta/early release/limbo/interim versions and definitely not upgrade your team's SSMS until then (if you want them to use Source Control with it). Let me know if you have any questions or issues with that! Warmly, / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. sourcecontrol 4.2 worked with sql 2016 ctp but broke on RC0
Thanks for reporting that Warren, Our team has definitely become aware of this recently- we are currently working on compatibility issues with future versions of SSMS. Currently we do not officiall...
0 votes
Thanks for contacting us! We don't have support for comparing to Labels specifically, however you can compare it to a specific revision. Some more info on setting Comparison Sources here https://documentation.red-gate.com/disp ... ta+sources If you would like additional support for Labels I highly suggest you post your idea to our UserVoice feature request forum https://redgate.uservoice.com/forums/141379-sql-compare Please let me know if you have any questions or issues with the above! Warmly, / comments
  1. Community
  2. SQL Compare 11
  3. Support for TFS Labels
Thanks for contacting us! We don't have support for comparing to Labels specifically, however you can compare it to a specific revision. Some more info on setting Comparison Sources here https://do...
0 votes
I've followed up with you via email, below is a transcript: Thanks for contacting us and sorry you are having this issue! Next time you get this issue could you send in a screenshot as well as the latest log from ``C:Users%Username%AppDataLocalRed GateLogsSQL Prompt 7`` Feel free to reply back at your convenience! Warmly, / comments
  1. Community
  2. SQL Prompt
  3. auto table alias in subquery sometimes doesnt work
I've followed up with you via email, below is a transcript: Thanks for contacting us and sorry you are having this issue! Next time you get this issue could you send in a screenshot as well as the ...
0 votes
Thanks for contacting us and sorry you are having this issue! Would you mind closing SSMS then going to Control Panel-> Programs and Features and Repair the SSMS Integration Pack Framework as well as SQL Search. Let me know if you have any issues with that- I will be following up with you via email just in case! Warmly, / comments
  1. Community
  2. SQL Search
  3. search not available in 2012 ssms
Thanks for contacting us and sorry you are having this issue! Would you mind closing SSMS then going to Control Panel-> Programs and Features and Repair the SSMS Integration Pack Framework as well ...
0 votes
Total activity
362
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
175