User profile for Andrew P

Hey mkzeke, Thanks for contacting us! The best way to do this is using a PowerShell script where your would input the database/server names into a variable as a comma separated list and generate the command line syntax foreach name on that list and have it execute each statement in the Powershell script. Here is a good article on setting that up https://www.simple-talk.com/blogs/2014/ ... mand-line/ Kind Regards, / comments

Hey mkzeke, Thanks for contacting us! The best way to do this is using a PowerShell script where your would input the database/server names into a variable as a comma separated list and generate th...

0 votes

Hey Umamahesh, Thanks for contacting us! There is currently no option to create Confluence wiki pages from Doc- I have added a feature request for it SDOC-1725 However you might be able to work around this using the HTML format. I will follow up with you via email in case you have any further questions or issues. Warmly / comments

Hey Umamahesh, Thanks for contacting us! There is currently no option to create Confluence wiki pages from Doc- I have added a feature request for it SDOC-1725 However you might be able to work aro...

0 votes

Hello, Thanks for contacting us and sorry you are having this issue! There are not any known issues with Data Compare and migrating data to databases with different filegroups; if there was an issue, I suspect it would be a timeout because Data Compare runs all of the inserts in one long transaction. You can split the transaction if you don't mind a partial deployment if the script fails https://documentation.red-gate.com/disp ... on+options I would need the error message for more information- a screenshot would help, as would the logs. Note that you have to enable logging in Data Compare https://documentation.red-gate.com/disp ... +log+files Kind Regards, / comments

Hello, Thanks for contacting us and sorry you are having this issue! There are not any known issues with Data Compare and migrating data to databases with different filegroups; if there was an issu...

0 votes

Hey Batts, By default the "include dependencies" option is enabled in the command line- in the GUI it will give you the opportunity to include or exclude dependencies. To Joe, I highly recommend you upgrade to v11 and retest - v11 installs alongside v10 so you can revert painlessly. Kind Regards, / comments

Hey Batts, By default the "include dependencies" option is enabled in the command line- in the GUI it will give you the opportunity to include or exclude dependencies. To Joe, I highly recommend yo...

0 votes

Hey joemomberg, Thanks for contacting us and sorry you are having this issue! Did you have this xml script working previously? If you remove the <exclude> lines then does it still compare the roles? (it should only compare the items that are explicitly included unless you have the "IncludeDependencies" option on as well) What version of SQL Compare are you using? I will follow up with you via email for further troubleshooting. Kind Regards, / comments

Hey joemomberg, Thanks for contacting us and sorry you are having this issue! Did you have this xml script working previously? If you remove the <exclude> lines then does it still compare the roles...

0 votes

Thanks for contacting us and for your interest! I believe that the answer to this is Yes it is still active, but I have pinged the devs to see if they have some insight on this. Here is the documentation on the ecosystem https://documentation.red-gate.com/disp ... em+project Kindly, / comments

Thanks for contacting us and for your interest! I believe that the answer to this is Yes it is still active, but I have pinged the devs to see if they have some insight on this. Here is the documen...

0 votes

Hey Neil, Thanks for contacting us and sorry you are having this issue! I working with the devs on this currently and I have followed up with you via email for further troubleshooting. Kind Regards, / comments

Hey Neil, Thanks for contacting us and sorry you are having this issue! I working with the devs on this currently and I have followed up with you via email for further troubleshooting. Kind Regards,

0 votes

Thanks for posting! As you noted there is the option to "Ignore indexes" - but it ignores all indexes so it is not selective. If you would like to selectively deploy indexes I highly suggest you add that idea to our UserVoice Feature Request forum available here https://redgate.uservoice.com/forums/141379-sql-compare I have also followed up with you via email for further Q&A. Kind Regards, / comments

Thanks for posting! As you noted there is the option to "Ignore indexes" - but it ignores all indexes so it is not selective. If you would like to selectively deploy indexes I highly suggest you ad...

0 votes

Hey ppat, Thanks for your post! There is currently no way to do this but there is an existing feature request for this available on here https://redgate.uservoice.com/forums/39 ... -selection I highly suggest you comment/vote on this idea if you would like to see it implemented- please let me know if I can be of service in any other way- I have followed up with you via email as well. Warmly, / comments

Hey ppat, Thanks for your post! There is currently no way to do this but there is an existing feature request for this available on here https://redgate.uservoice.com/forums/39 ... -selection I hig...

0 votes

Hey Darkoverlord, Thanks for contacting us! It is a bit confusing but you would need to use Data Compare and set the source to Source Control https://documentation.red-gate.com/disp ... ta+sources I have also followed up with you via email for further issues/questions! Best, / comments

Hey Darkoverlord, Thanks for contacting us! It is a bit confusing but you would need to use Data Compare and set the source to Source Control https://documentation.red-gate.com/disp ... ta+sources ...

0 votes

How can we help you today?

Andrew P

Comments