Comments
Sort by recent activity
Hey acrawford
Thanks for contacting us and sorry you are having this issue- below is a copy-paste of what I sent via email
What type of object are they attempting to commit?
What version of SQL Source Control are they using (4.x.x.x)?
Would you mind sending in a screenshot of the error message?
Thanks for your help! / comments
Hey acrawford
Thanks for contacting us and sorry you are having this issue- below is a copy-paste of what I sent via email
What type of object are they attempting to commit?
What version of SQL Sou...
Hey Shawn,
Thanks for contacting us and sorry you are having this issue- this is just a copy-paste of what I sent via email.
I assume that you used this documentation when working through the migration script https://documentation.red-gate.com/disp ... t+examples
Can you confirm that you first committed your Update Migration script (the one you sent over) then committed the NOT NULL constraint change to the column - then went to deploy using SQL Compare?
If the NOT NULL column change was already made/committed prior to committing the migration script then you will need to follow the steps for Historical Migration scripts https://documentation.red-gate.com/disp ... on+scripts
Do let me know if you have any issues with that! / comments
Hey Shawn,
Thanks for contacting us and sorry you are having this issue- this is just a copy-paste of what I sent via email.
I assume that you used this documentation when working through the migra...
Thanks for your post jmeyer,
I have responded via email to get more information about what you are seeing.
Kind Regards, / comments
Thanks for your post jmeyer,
I have responded via email to get more information about what you are seeing.
Kind Regards,
Hey Jmeyer,
Thanks for contacting us and sorry you are having this issue!
If the primary key, index, or unique constraint is the comparison key, it can't be dropped. https://documentation.red-gate.com/disp ... ct+options
That said - what version are you using currently (11.x.x.x)?
Would you mind sending in an example of this issue?
Thanks! / comments
Hey Jmeyer,
Thanks for contacting us and sorry you are having this issue!
If the primary key, index, or unique constraint is the comparison key, it can't be dropped. https://documentation.red-gate....
Dsbert,
Thanks for contacting us and sorry you are having this issue- below is just a copy paste of what I sent via email.
I believe this may have to do with line ending characters- what version of SQL Source Control are you using currently?
Would you be able to test this with the latest Frequent Updates version? http://documentation.red-gate.com/displ ... nt+Updates
Can you send in a screenshot of what you are seeing in Source Control?
Do you see this with any other databases that you have linked?
Would you be able to send in one of the scripts directly from the Git repo and another directly from the database (script as Create to file)?
Thanks for your help!
Warmly, / comments
Dsbert,
Thanks for contacting us and sorry you are having this issue- below is just a copy paste of what I sent via email.
I believe this may have to do with line ending characters- what version of...
Hey wbmarshall,
Thanks for that suggestion!
I have added this to a similar feature request SE-629 and reported it to the project managers for potential future work.
Do let me know if you have any other requests or questions!
Best, / comments
Hey wbmarshall,
Thanks for that suggestion!
I have added this to a similar feature request SE-629 and reported it to the project managers for potential future work.
Do let me know if you have any o...
Hey JK,
Thanks for your post!
This is related to the "Object changed by Unknown" issue when the user does not have the appropriate permissions to view the information about who committed previously - the "Last changed by" column just says "unknown" https://documentation.red-gate.com/disp ... by+Unknown
You can get around this by asking your dba to grant you execute permissions on either Tempdb or on the 'RG_WhatsChanged_v4' object which polls the default trace to get the "Last changed by" information.
I have also followed up with you via email in case you have any further issues or questions.
Kind Regards / comments
Hey JK,
Thanks for your post!
This is related to the "Object changed by Unknown" issue when the user does not have the appropriate permissions to view the information about who committed previously...
Hey JK,
Thanks for your post!
This is related to the "Object changed by Unknown" issue when the user does not have the appropriate permissions to view the information about who committed previously - the "Last changed by" column just says "unknown" https://documentation.red-gate.com/disp ... by+Unknown
You can get around this by asking your dba to grant you execute permissions on either Tempdb or on the 'RG_WhatsChanged_v4' object which polls the default trace to get the "Last changed by" information.
I have also followed up with you via email in case you have any further issues or questions.
Kind Regards / comments
Hey JK,
Thanks for your post!
This is related to the "Object changed by Unknown" issue when the user does not have the appropriate permissions to view the information about who committed previousl...
Hey blicket,
Thanks for contacting us!
There is nothing like that currently on the roadmap, but we have not ruled anything out so I recommend you request this feature on our Uservoice site https://redgate.uservoice.com/forums/39 ... ce-control
Do let me know if you have any other questions or issues!
Regards, / comments
Hey blicket,
Thanks for contacting us!
There is nothing like that currently on the roadmap, but we have not ruled anything out so I recommend you request this feature on our Uservoice site https://...
Hey Jbrune,
Thanks for contacting us!
In cases where you would want to apply scripts (stored in the repository) to the database - you would use link to the repository folder using the Dedicated model- which gives you the option to "Get latest" from the repository because it assumes that each developer has their own copy of the database and they are committing to and getting from that same folder. See the "Switching to dedicated development" model for information on how to set that up https://documentation.red-gate.com/disp ... ated+model
If you are using the Shared model - then Source Control assumes that developers work on a single copy of the database- so you can only Commit to the repository, because no changes would be made to the repository before they were made to the database. https://documentation.red-gate.com/disp ... ared+model
Do let me know if you have any questions or issues about the above!
Warmly, / comments
Hey Jbrune,
Thanks for contacting us!
In cases where you would want to apply scripts (stored in the repository) to the database - you would use link to the repository folder using the Dedicated mod...