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 aspillert, Thanks for contacting us! SQL Compare can compare a database to itself, however it only maps stored procedures based on object and owner name - so if you created "dbo.p_training" as well as "test.p_training" you could map those using Owner mapping - see documentation here https://documentation.red-gate.com/disp ... ing+owners Warmly, / comments
  1. Community
  2. SQL Compare
  3. Compare two different stored procedures?
Hey aspillert, Thanks for contacting us! SQL Compare can compare a database to itself, however it only maps stored procedures based on object and owner name - so if you created "dbo.p_training" as ...
0 votes
Hey Richard, Thanks for contacting us! Currently, Generating to or connecting to SSDT folders is beta/unsupported functionality https://documentation.red-gate.com/disp ... DT+project So there is no way to generate SSDT compatible scripts folders from the command line right now. If you would like to see this in the future, I recommend you post your idea here https://redgate.uservoice.com/forums/141379-sql-compare We did fix a bug relating to SSDT extended properties in v11.4 - I would recommend upgrading to that version or later if you have not already. Warm Regards, / comments
  1. Community
  2. SQL Compare
  3. Using SsdtCompatibleOptions from Command Line
Hey Richard, Thanks for contacting us! Currently, Generating to or connecting to SSDT folders is beta/unsupported functionality https://documentation.red-gate.com/disp ... DT+project So there is no...
0 votes
Hey pyeldi11, Thanks for contacting us and sorry you are having this issue - below is just a copy paste from the email I sent. I would recommend you alter your ``/Include:`` syntax a bit eg ``SqlDataCompare /S1:MyServer/Db1:Source /S2:MyServer /Db2:Destination /Include:table:[test] /Include:Identical /v /sync`` or ``SqlDataCompare /S1:MyServer/Db1:Source /S2:MyServer /Db2:Destination /Include:table:[dbo].[test] /Include:Identical /v /sync`` Let me know if you continue to have issues after that! / comments
  1. Community
  2. SQL Data Compare
  3. SQL Data Compare Command Line
Hey pyeldi11, Thanks for contacting us and sorry you are having this issue - below is just a copy paste from the email I sent. I would recommend you alter your ``/Include:`` syntax a bit eg ``SqlDa...
0 votes
Hey Jshaffer0418 Thanks for contacting us! You need to check the checkbox called ``Show advanced options`` - that will give you the option to set the transaction Isolation level for each of the steps. [image] / comments
  1. Community
  2. DLM Automation
  3. Transaction Isolation level - VSTS - Redgate DLM Automation
Hey Jshaffer0418 Thanks for contacting us! You need to check the checkbox called ``Show advanced options`` - that will give you the option to set the transaction Isolation level for each of the st...
0 votes
Hey Eli, Thanks for contacting us! Below is just a copy paste of what I sent via email. I'm afraid I am not following - you have committed views to the repository, then you are trying to Get them from the repository on another database, and it is failing - is that correct? If you are trying to use it for deployments (from database to database, or repository to database) - I recommend you use SQL Compare instead - as you can be more selective about what you deploy and how, and there is better visibility for what you are actually deploying. I recommend you try it out if you have not already. http://www.red-gate.com/products/sql-de ... l-compare/ Warm Regards / comments
  1. Community
  2. SQL Source Control
  3. Adding views even if some fail
Hey Eli, Thanks for contacting us! Below is just a copy paste of what I sent via email. I'm afraid I am not following - you have committed views to the repository, then you are trying to Get them f...
0 votes
Hey noffie, Thanks for contacting us! There is no option to ignore the Lock_Escalation syntax currently. If that would be useful for you then I recommend you post it to our UserVoice feature request website where other users can comment and vote on the idea. Here is the link to that https://redgate.uservoice.com/forums/141379-sql-compare Here is the full list of our project options in SQL Compare https://documentation.red-gate.com/disp ... ct+options Do let me know if you have any other questions or issues! Warmly, / comments
  1. Community
  2. SQL Compare
  3. Ignore LOCK_ESCALATION change on table
Hey noffie, Thanks for contacting us! There is no option to ignore the Lock_Escalation syntax currently. If that would be useful for you then I recommend you post it to our UserVoice feature reques...
0 votes
Hey DSAUser, Thanks for contacting us! Setting up the command line hooks with all of your information is the only real way to use non-native version control systems with SQL Source Control. If you would like native support to be added, I recommend that you post your idea to our UserVoice forum available here https://redgate.uservoice.com/forums/39 ... ce-control I have followed up with you via email in case you have any other questions or issues! / comments
  1. Community
  2. SQL Source Control
  3. SourceAnywhere and SQL Source Control
Hey DSAUser, Thanks for contacting us! Setting up the command line hooks with all of your information is the only real way to use non-native version control systems with SQL Source Control. If you ...
0 votes
Thanks for contacting us and sorry you are having this issue! There is no way to get rid of the warnings- and there is no filter that applies to referenced objects - I recommend you post that to our UserVoice forum available here https://redgate.uservoice.com/forums/39 ... ce-control Also, it sounds like you are using the tool to sync Prod environments - SQL Source Control is meant for development environments only. It was not made for Prod environments at all, instead, we recommend you use SQL Compare for syncing databases between environments. Warm Regards, / comments
  1. Community
  2. SQL Source Control
  3. Handling of Sequences
Thanks for contacting us and sorry you are having this issue! There is no way to get rid of the warnings- and there is no filter that applies to referenced objects - I recommend you post that to ou...
0 votes
Hey Brock, Thanks for contacting us! CLR exclusion is a known issue https://documentation.red-gate.com/disp ... DT+project If you are really interested in further SSDT project support - I recommend you post over in our UserVoice forum available here https://redgate.uservoice.com/forums/39 ... ce-control I have also reached out via email in case you have any further questions- hope you have a great weekend! Warm Regards, / comments
  1. Community
  2. SQL Compare
  3. Project-Refrenced CLR Assemblies Not Recognized
Hey Brock, Thanks for contacting us! CLR exclusion is a known issue https://documentation.red-gate.com/disp ... DT+project If you are really interested in further SSDT project support - I recommend...
0 votes
Hey Vijay, Thanks for your post! What version were you using previously and what version are you using now? I tested this in v11.6 and it re-compares if you switch the direction. Regards, / comments
  1. Community
  2. SQL Data Compare
  3. On Switch Deployment Direction
Hey Vijay, Thanks for your post! What version were you using previously and what version are you using now? I tested this in v11.6 and it re-compares if you switch the direction. Regards,
0 votes
Total activity
362
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
175