Comments
Sort by recent activity
Change tracking will be fully supported in SQL Compare 8; there is a release candidate already available
Simon C / comments
Change tracking will be fully supported in SQL Compare 8; there is a release candidate already available
Simon C
SQL Server 2008 removed a function that SQL Compare 6.2 and below used during population. I'm afraid you need to use SQL Compare 7.0 or above to compare SS2008 databases, even in compatability mode.
Simon C / comments
SQL Server 2008 removed a function that SQL Compare 6.2 and below used during population. I'm afraid you need to use SQL Compare 7.0 or above to compare SS2008 databases, even in compatability mode...
With the new mappings, you can't leave dbo unmapped on one side. Am I correct in thinking your mappings are like this: Source Target
Schema1 <-> dbo
dbo <->
If so, SQL Compare shouldn't compare the database like this. Internally, SC creates a clone of the source database and manually applies all the mapping renames and refactorings to the clone. Here, Schema1 will be renamed to dbo. The problem is, dbo already exists, and isn't mapped to anything itself. If there is a [Schema1].[table1] and [dbo].[table1] in the source, or even permissions on the Schema1 or dbo schema objects that aren't on the other, we don't know which one to use. So I'm afraid you can't map a schema onto one that already exists; a workaround is to create a Schema2 in the target and map dbo in the source to Schema2 in the target. / comments
With the new mappings, you can't leave dbo unmapped on one side. Am I correct in thinking your mappings are like this:Source Target
Schema1 <-> dbo
dbo <->
If so, SQ...
Could you try this on the release candidate? Several bugs relating to mappings have been fixed between the beta and the RC
Simon C / comments
Could you try this on the release candidate? Several bugs relating to mappings have been fixed between the beta and the RC
Simon C
In the current commandline the includeIdentical option is only used when generating reports using the /report switch. In the 8.0 release, there will be commandline options to exclude additional, different and missing objects from the comparison and synchronization.
May I ask in what situations you want to exclude identical objects from the comparison?
Simon C / comments
In the current commandline the includeIdentical option is only used when generating reports using the /report switch. In the 8.0 release, there will be commandline options to exclude additional, di...
This has been requested before, and it's in our bug database (SC-4188). Unfortunately, SSMS or QA don't provide any command line option to use an existing window to open a file. Until Microsoft adds a command line option or an API of some sort to use an existing window, I'm afraid we have to open a new window every time [image]
If you've got an editor application that does have a commandline option to do so, then you can specify that as the 'custom editor' in the application options.
Simon C / comments
This has been requested before, and it's in our bug database (SC-4188). Unfortunately, SSMS or QA don't provide any command line option to use an existing window to open a file. Until Microsoft add...
Just the thing you're looking for is included in the 8.0 beta, with the 8.0 release available in february/march. Any feedback you want to give on the parser error messages dialog, or any other new feature, would be greatly appreciated
Simon C / comments
Just the thing you're looking for is included in the 8.0 beta, with the 8.0 release available in february/march. Any feedback you want to give on the parser error messages dialog, or any other new ...
Have you got any views specified WITH ENCRYPTION? If a database does, and the 'Decrypt encrypted objects on 2005 and 2008 database' option is turned on, then SQL Compare reads the pages containing the object text directly from SQL Server using DDBC PAGE and reads the encrypted text from there. Unfortunately, this takes time proportional to the total number of text objects in your database. You could try turning off this option in the project options screen & see if that improves the population time.
Simon C / comments
Have you got any views specified WITH ENCRYPTION? If a database does, and the 'Decrypt encrypted objects on 2005 and 2008 database' option is turned on, then SQL Compare reads the pages containing ...
The filter rules toolbar can be closed by clicking on the 'Filter Setup' button on the toolbar
Simon C / comments
The filter rules toolbar can be closed by clicking on the 'Filter Setup' button on the toolbar
Simon C
This was a bug in the beta, and has been fixed in our internal builds. Thanks for letting us know! / comments
This was a bug in the beta, and has been fixed in our internal builds. Thanks for letting us know!