Comments
Sort by recent activity
I Can't hardly wait. / comments
I Can't hardly wait.
Not just that.
Imagine I have a SS2000 or SS2005 database with a table with DATETIME column and a SS2008 version of the same database where the table has DATETIMEOFFSET(0) instead of DATETIME columns. Chances are that values from one will never be equal to values in the other because DATETIMEOFFSET(0) has no milliseconds part.
Another use case is where I have a timestamp column that I don't want in the comparison but, in the synchronization script I want it to be GETUTCDATE(). / comments
Not just that.
Imagine I have a SS2000 or SS2005 database with a table with DATETIME column and a SS2008 version of the same database where the table has DATETIMEOFFSET(0) instead of DATETIME colum...
I can't hardly wait. [image] / comments
I can't hardly wait.
I was just working on a database project in Visual Studio 2010 Ultimate and got this (reported by NDepend - www.ndepend.com). / comments
I was just working on a database project in Visual Studio 2010 Ultimate and got this (reported by NDepend - www.ndepend.com).
The cumulative patch fixed it. Thanks. / comments
The cumulative patch fixed it. Thanks.
Thanks. I was able to work around the issue using SQL Refactor. / comments
Thanks. I was able to work around the issue using SQL Refactor.
Seems like that's it.
A friend of mine, has SQL Data Compare version 6 and the same happens. Although his version has an option in the differences pane to show the SQL Script only for the selected row. Is that option available in SQL Data Compare 8? / comments
Seems like that's it.
A friend of mine, has SQL Data Compare version 6 and the same happens. Although his version has an option in the differences pane to show the SQL Script only for the selected ...
I might have missed the "try to include/exclude specific rows from the sync" because that's the way I use it most of the time. / comments
I might have missed the "try to include/exclude specific rows from the sync" because that's the way I use it most of the time.
Hi!
I'm generating the script in the UI of SQL Data Compare.
I'm comparing a database that has tables in the MySchema schema with a database that has table in the dbo schema.
I've definded mappings such that MySchema.MyTable is compared with dbo.MyTable.
I don't have a where clause.
In the comparsion results window I can see the correct count of left only, different and right only. But, when I generate the synchronization script from left to right, the generated script has inserts on the right table for all rows in the left table.
It definetly happened before 8.0.2.5 (my bad for not reporting before), but I'm not able to reproduce it today. / comments
Hi!
I'm generating the script in the UI of SQL Data Compare.
I'm comparing a database that has tables in the MySchema schema with a database that has table in the dbo schema.
I've definded mappings...
Cool! / comments
Cool!