Posts
Sort by recent activity
ASYNC_NETWORK_IO wait causing data compare to fail
We run a continuous integration process using SQL Data Compare Pro. This morning our build tasks started to fail when comparing one particular table (the only one with a data difference).
Looking ...
Constraint names when rebuilding tables
(Apologies - this doesn't seem to be a problem as constraints are deleted further up the script)
Problems with case sensitivity varchar comparisons
For a while now the scripts that have been generated comparing data between my dev and test databases have always included the following:
-- Drop constraints from [dbo].[tbTask_Class_Setting]
ALTER...
Auto-update for Red Gate applications
I couldn't find a general "Red Gate" forum here so I'm posting to the SQL Compare one.
I really like the fact that you guys frequently release patches and new versions of your software, however I d...
Object reference not set exception generating script
I am comparing a particular table using a custom comparison key and a WHERE clause and now cannot generate scripts or synchronise databases as an "Object reference not set" error is appearing.
* Th...
Default tab "Commit Changes" or "Get Latest"?
Maybe just for discussion, but would it not be better to have "Get Latest" as the default first tab in SQL Source Control?
I would expect that developers would probably want to get latest version b...
Synchronize AND save script file using command line
I almost have continuous integration setup with TeamCity but have come up with another hitch:
I want to apply the changes to our test database from subversion (using the "/synchronize" switch), AN...
Command line "selected objects are identical or no objects"
If I open a SQL Compare project file and run a comparison via the application, 4 differences are noted.
If I then run the command line:
sqlcompare /project:[project file]
It says:
Error: The select...
Overriding project server and database via command line
I am setting up a continuous integration process, which will synchronise my test database with any changes made to SubVersion (via SQL Source Control).
I've created SQL Compare and SQL Data Compare...
Object reference not set to an instance of an object errors
I managed to commit quite a few objects to SVN, but on many I am getting an Object reference not set to an instance of an object exception.
Anyone else getting this?
Some system information:
- Usin...