Activity overview
Latest activity by Jeff Clark
SQL SC disabled within SSMS
I have been using SQL SC 4 within SSMS for SQL Server 2014 v. 12.0.4459.0 for some time now.
When I went to use it today, SQL Source Control was missing and none of the linked databases showed as l...
This issue re-occurred for us this morning. We had restored our (shared) source controlled databases from production.
We had to clear our local data caches again to fix the error.
Could you handle this fix automatically in the future?
Thanks. / comments
This issue re-occurred for us this morning. We had restored our (shared) source controlled databases from production.
We had to clear our local data caches again to fix the error.
Could you handle...
Andrew suggested I try clearing the local data cache:
Try clearing the contents of each folder in %localappdata%Red GateSQL Source Control 4Caches- move them to an alternate folder first so that Source Control rebuilds them and see if you still have this issue.
That worked. Great. Thanks. Issue resolved. / comments
Andrew suggested I try clearing the local data cache:
Try clearing the contents of each folder in %localappdata%Red GateSQL Source Control 4Caches- move them to an alternate folder first so that S...
Error: All keys contained ... but neither existingResults...
When I go to the Commit Changes tab for a particular database, I get this error (and other users get it as well):
All keys contained 1597506878 but neither existingResults or newResults contained t...
Adding a nonnull column removes triggers on save changes
I'm adding a non-null column to an existing table with data in SQL Source Control 4.0.0.181. My script populates the column with a default value and then removes the default constraint:
ALTER TAB...
Thanks, Sergio.
I look forward to seeing what you come up with.
Thanks,
Jeff / comments
Thanks, Sergio.
I look forward to seeing what you come up with.
Thanks,
Jeff
Hi Sergio,
Yes, I am looking for something like migration scripts. That would solve not only this issue but broader issues of adding new non-null columns to tables - which we do fairly frequently.
However, we are using Git for source control and a shared database in our development. Will either of these be supported in V2 when it gets out of beta or other version in the foreseeable future? We need a solution we can use in our production work right away.
Thank you in advance for your assistance.
Jeff / comments
Hi Sergio,
Yes, I am looking for something like migration scripts. That would solve not only this issue but broader issues of adding new non-null columns to tables - which we do fairly frequently....
Renaming table loses data
If I rename a table and check the changes into source control, when I run SQL Compare of the sourced controlled schema against another database, the change script generated simply drops the table w...