Posts
Sort by recent activity
An item with the same key has already been added
In SQL Compare 6 Beta (1013), I am synchronizing changes that include 3 tables, a view, a role, an assembly, 2 xml schema collections, a stored proc and a user. At the calculating dependencies step...
Feature request for next version
It would be nice if I could export the the list of warnings in the Warnings tab of the Summary stage of the Synchronization dialog. Copying to the clipboard in plain text would be sufficient.
Also,...
Excessive changes
I have changed the REFERENCES permission on a user defined type in one database and I am trying to sync that to another. In this minimal case, the only change required on target db is:
REVOKE REFER...
Bug in UDT change script
Hello,
I have two copies of a database. I make changes in one and when I have done some testing and am happy with them I use SQL Compare 5.3 to replicate the changes to the other copy.
I have a tab...
Compare Database Options
Hello,
I am using SQL Compare 5.3.0.44 to compare two SQL Server 2005 databases. When I look in SQL Server Management Studio I can see that the database object itself is different between the two i...
Request improvement to generated scripts
The scripts generated by SQL Compare and other Red Gate products (ie SQL Refactor) output a PRINT 'Some Action' line before the actual action. This is very useful when a script fails because I can ...
SQL Compare Check For Updates Bug
SQL Compare 5.2.0.32 will throw a SecurityException while trying to access the registry if a non-admin user clicks Check For Updates on the Help menu.
I'm guessing this is because SQL Compare tries...
Computed column renaming
A portion of a script generated by SQL Compare 5.1 looks like this:
PRINT N'Altering [dbo].[doMaster]'
GO
sp_rename N'[dbo].[doMaster].[GLAccount]', N'GlAccount', 'COLUMN'
GO@TRANCOUNT>0 ROLLBAC...
Update user-defined function used by computed column
We have a table containing a computed column that uses an expression calling a scalar user-defined function.
When we alter our user-defined function we temporarily change the table's computed colum...
CLR Assembly comparison must always be case-sensitive
We recently made some changes in our database to a CLR assembly that involved some case-only changes to the namespace and some class names. SQL Server 2005 seems to be very picky that all CLR refer...