Posts
Sort by recent activity
SSC History launches SDC without project settings
Hey RG,
SQL Source Control's History function launches SQL Data Compare without any project settings. (version 3.5.3.29).
We find the History function useful for testing migration scripts. It would...
Migration script fails to set DB rev, modifies SP instead
Hey guys,
Today we created and tested a custom migration script for a complex schema change.
The migration script failed to set the revision number extended property, which caused an error in a lat...
Case-sensitive comparison makes the repository messy
I'm in favor of case-sensitive comparison as a principle.
SQL Compare's implementation causes some issues, though.Enabling Case Sensitivity
Case sensitivity is enabled through the 'Use case sensiti...
Can't synchronize mapping between users and logins
SQL Compare can't synchronize the mapping between users and logins.
If the user is defined as WITHOUT LOGIN in the database and FOR LOGIN in the repository, SQL Compare can detect the change, but i...
HOWTO: Share a filter with your team
The easiest way to share a filter with your team is to add it to the repository.
SQL Compare can read project filters and write them to your documents folder, but it can't write them to the project...
/project switch help is misleading
To see the verbose help, run this command:SQLCompare.exe /verbose /help
The help for the /project switch contains a message like this:/project:<project> (Alias: /pr)
Uses a SQL ...
SQLCompare.exe ignores project filters
Summary
I have a SQL Compare project file that I can use to deploy my GeoDB database schema from SVN to a target database.
I want to use the file to deploy to several databases. I believe using SQL...
You can't exclude schemas by schema name
In my development database I want to exclude the tSQLt schema and all objects in the schema.
I have configured the filter rules dialog to look like this:
In the diff viewer it looks like this:-- Al...
Can I exclude hidden objects from dependency list export?
My dependency tracker version is 2.7.4.1.
How do I export a dependency list for only the visible objects in the project?
The dependency export feature seems only to export a dependency list for all...
Delete deprecated XML File System.String[] from repository
I'm using SQL Compare to script out a new object into version control.
I compared a database to my local scripts folder and selected one stored procedure for 'deployment'.
The Files tab lists two f...