Posts
Sort by recent activity
SCHEMABINDING issues
Hello,
We have a lot of views with SCHEMABINDING.
It often happens that SQL Compare will miss a dependency and attempt to alter a table referenced by a schema bound view without first altering the ...
"Ignore Indexes" not working in GUI
Hello,
I'm confused.
I'm comparing a single table using the GUI (SVN to DB compare) and I have the following options set:
"Ignore Indexes" = true
"Ignore Constraint Names" = false
"Ignore Check Con...
Altering a column with indexes
Hi there,
I compared two tables that were identical except for a changed datatype on ColumnA and some indexes, one of which accessed ColumnA - we'll call it IDX_ColumnA. My goal was to sync the da...
Option to "Commit all dependencies (recommended)"
Hello,
When you try to commit something that has dependencies you get the window that pops up with the list of dependent objects giving you the option to commit them as well. I'm wondering 2 thing...
Filter objects beginning with an underscore
Hello,
Our DB naming convention is to prefix temporary objects with an underscore. Is there a way to filter these objects out of the SSC Commit tab?
A filter with just an underscore filters everyt...
Outstanding changes to be checked in
Hello,
I'd like to set up a nightly process that will remind our Devs to check in their changes.
Is there a way to see outstanding changes that haven't been checked in yet without using the GUI; ma...
Blame
Hello,
We make a lot of changes to our databases using Multi Script (Windows authentication).
We also use SQL Source Control.
The problem is when changes are made via Multi Script, we can't see who...
Nested trunk folders
Hello,
I'm doing a SQL Compare command line sync from an SVN source control repository to a database.
The repository has an odd setup with multiple trunk folders nested under a single trunk folder....
Overhead from SSC SPIDs
Hello,
I have 20 databases on a particular server and 14 of them are actively linked to a repository on my machine through SSMS.
We've had some odd/unusual performance issues since I linked them. ...
Lots of static data to link
Hello,
I have between 50 and 100 tables containing static data (I know...it's a lot) that I need to version in SQL Source Control. The trouble is, those tables exist in about 40 databases across o...