Comments
Sort by recent activity
@lpribble, have you reported this to support@red-gate.com? / comments
@lpribble, have you reported this to support@red-gate.com?
Can you try adding the <force/> tag to your XML and see if that fixes your issue? See the bolded text below... <?xml version="1.0" encoding="UTF-8"?> <span><commandline><br></span> <span> <database1>database1</database1><br></span> <span> <username1>username1</username1><br></span> <span> <password1>password1</password1><br></span> <span> <server1>server1</server1><br></span> <span> <database2>database2</database2><br></span> <span> <username2>username2</username2><br></span> <span> <password2>password2</password2><br></span> <span> <server2>server2</server2><br></span> <span> <options>Default</options><br></span> <span> <options>DisableAndReenableDDLTriggers</options><br></span> <span> <options>DisableAndReenableDMLTriggers</options><br></span> <span> <synchronize/><br></span> <span> <include>Table</include><br></span> <span> <include>Table:\[Yadda\]</include><br></span> <span> <include>Table:\[Yadda1\]</include><br></span> <span> <include>Table:\[Yadda2\]</include><br></span> <span> <include>Table:\[Yadda3\]</include><br></span> <ExcludeColumns>Yadda3]$:Status</ExcludeColumns> <b><force/></b><br> </commandline> / comments
Can you try adding the <force/> tag to your XML and see if that fixes your issue? See the bolded text below...<?xml version="1.0" encoding="UTF-8"?><span><commandline><br></span><span> <data...
@mattkollar can you send me what your command line looks with the argfile switch contents? I have done some work like this so I could probably help if you could give me some additional details. / comments
@mattkollar can you send me what your command line looks with the argfile switch contents? I have done some work like this so I could probably help if you could give me some additional details.
@jjj, have you reported this to support@red-gate.com? / comments
@jjj, have you reported this to support@red-gate.com?
@Yev, you may want to post this on SQL Prompt's UserVoice. Here's the link: https://redgate.uservoice.com/forums/94413-sql-prompt / comments
@Yev, you may want to post this on SQL Prompt's UserVoice. Here's the link: https://redgate.uservoice.com/forums/94413-sql-prompt
There really isn't a way to accomplish this that I know of in SQL Source Control. However, if you have SQL Compare and/or SQL Data Compare, you can use the Command Line tool to compare between your source and target and export a report file of the objects that are changing. / comments
There really isn't a way to accomplish this that I know of in SQL Source Control. However, if you have SQL Compare and/or SQL Data Compare, you can use the Command Line tool to compare between you...
Yes, you can do this in the Options screen of the Project you setup. There is an option to 'Ignore DML triggers' I do not see an option for ignoring DDL triggers though, but maybe DML is all you need? / comments
Yes, you can do this in the Options screen of the Project you setup. There is an option to 'Ignore DML triggers' I do not see an option for ignoring DDL triggers though, but maybe DML is all you ...
To get the scriptsfolderxml file you need to go into SQL Source Control for the specific database you are comparing against. Then go to the 'Under the Hood' section and you will see a section labeled 'SQL Compare XML fragment'. That will be the XML you are looking for. It should give you what you need. Good luck! / comments
To get the scriptsfolderxml file you need to go into SQL Source Control for the specific database you are comparing against. Then go to the 'Under the Hood' section and you will see a section labe...
@madnik7 I would think the only way to keep this from occurring is to use the feature that was added in SQL Prompt a few versions back that allows for a special comment to be used to force SQL Prompt to not format certain text. The comment is as follows:
-- SQL Prompt formatting off
<Whatever is between the comments lines won't be formatted
-- SQL Prompt formatting on
Other than that, I think the only solution would involve development. You could definitely post a suggestion on the SQL Prompt UserVoice here: https://redgate.uservoice.com/forums/94413-sql-prompt
I hope that helps.
--Adam Hafner / comments
@madnik7 I would think the only way to keep this from occurring is to use the feature that was added in SQL Prompt a few versions back that allows for a special comment to be used to force SQL Prom...
@BenKentzer , I actually opened a ticket with Red Gate support on this very issue. They found that for some reason SQL Source Control is not releasing itself from the instances when you deselect the database from the Object Explorer. They are aware of this and submitted a bug to development to resolve this, but it effects anyone running SSMS 2017. / comments
@BenKentzer , I actually opened a ticket with Red Gate support on this very issue. They found that for some reason SQL Source Control is not releasing itself from the instances when you deselect t...