How can we help you today? How can we help you today?
isme
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...
1 follower 1 comment 0 votes
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...
1 follower 1 comment 0 votes
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...
0 followers 0 comments 0 votes
/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 ...
2 followers 2 comments 0 votes
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...
2 followers 3 comments 0 votes
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...
0 followers 0 comments 0 votes
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...
3 followers 3 comments 0 votes
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...
2 followers 3 comments 0 votes
Invalid syntax in CREATE TYPE statement
My production logging server has received many ad-hoc changes over the past few months. I want to use SQL Compare to get the schema of the logging servers in testing in production in sync again to ...
2 followers 5 comments 0 votes
Static Data File Causes 'Non-Schema Statement Was Ignored'
I have a project to compare SVN with my local development database, in order to synchronize my development environment with the last changes in SVN. I clicked 'Compare Now' to compare the two schem...
3 followers 4 comments 0 votes