Posts
Sort by recent activity
Primary Key not synched if Indexes are ignored - FYI
This request is more for everyone else then me.
If you choose to ignore Indexes in your comparison, SQL Compare will not deploy the Primary Key with the table.
I understand that an index is associa...
Data Compare won't see my views
The Tables & Views tab (and Object Mapping tab) in SQL Data Compare doesn't list any of my views. Is this intentional?
I'd really like to be able to use a view to compare some data as there is no ...
Compare values in sys tables
I want to compare some SQL Agent job definitions in the MSDB database.
SQL Compare can't see them because they are not "objects" and SQL Data Compare doesn't see the sys tables.
Any suggestions? I...
Smart rename, last step disable constraints?
I'm using smart rename to rename a table and I noticed the very last action taken before 'The database updated succeeded' is to Disable the constraints on the newly named table.
PRINT N'Disabling c...
How to rollback changes
How do I rollback changes in SSC? I didn't see any option to undo changes that have been committed.
I had to manually script out and commit the script to undo previous changes.