Posts
Sort by recent activity
Random error: A duplicate object name has been found
We have a script that runs a comparison report between SVN and our production databases to make sure they stay in sync. However, it fails over 40% of the time with this error:
A duplicate object ...
can't exclude identical objects?!
Why does SQL Compare now include identical objects by default? I'm generating HTML reports that show the differences between Subversion and the production database, and since I upgraded to 10.3 th...
slow performance investigated
A while back I posted about SQL Source Control taking a very long time for remote users to link a database.
Since then, we've removed some large static tables, upgraded to the latest version of SQL...
temp files taking up lots of space
Hi,
My IT department told me that we were getting disk space warnings on our continuous integration server. Upon investigation, I found that there were 28 GB of temp files in C:\Users\build\AppDat...
error about unique column name
Hi,
I just updated to SQL Compare 10 on our build server, and now when I sync the database I get the following error:
Column names in each table must be unique. Column name 'foo' in table 'dbo.bar...
too many connections, slow for remote users
When linking a database to the repository, SQL Source Control is opening hundreds of TCP connections. I monitored it using TCP View, and during the linking process it opened over 1700 new connecti...
false error message: scripts folder contains parser errors
Hi, I've been seeing errors reported by our build system that I haven't been able to figure out. Here's a sample error message:Error: If statement in file
D:\build\Database\Security\Users\BUILTIN_...
problem with NoTransactions option?
I tried using /options:NoTransactions, and now my script includes a bunch of other objects that it shouldn't need for the sync. The script with transactions is 224KB, and the one with NoTransactio...
How do I sync just the tables that are in source control?
Hi,
I'm trying to use SQL Data Compare to sync my database with the changes in source control as part of a continuous integration system. I'm comparing against a script folder checked out from Sub...
Problem determining dependencies?
Hi,
I'm trying to synchronize my database and I keep getting errors such as the following:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_blah"
andProperty cannot be adde...