Posts
Sort by recent activity
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...
Error: Transaction context in use by another session
Hi,
I can't get the synchronization wizard to work at all. First I was getting the error: "MSDTC on server 'blah' is unavailable". So I went into services and enabled the Distributed Transaction ...