Activity overview
Latest activity by dsunbury
Can SQL Data Compare read a WHERE clause from a file?
Hi,
I'm using SQL Data Compare 6 on Windows XP Pro.
I have a comparison project which utilizes the WHERE clause on one of our tables. The clause changes every day so I need to make changes to the p...
I'll try this on the server in the US:
DateTimeStamp >= CONVERT(DATETIME, DATEADD(hour, - 63, GETDATE()), 102)
and this on the local server:
DateTimeStamp >= CONVERT(DATETIME, DATEADD(day, - 2, GETDATE()), 102)
and see how I go [image] / comments
I'll try this on the server in the US:
DateTimeStamp >= CONVERT(DATETIME, DATEADD(hour, - 63, GETDATE()), 102)
and this on the local server:
DateTimeStamp >= CONVERT(DATETIME, DATEADD(day, - 2, GET...
Hey Richard, your suggestion has prompted me to think about the time zones.
My local server is in US date format, but I am in Australia - the server I am trying to synchronize to is also in US date format, but physically situated in the US. So the getdate() function will give different results!
Hmmm, not sure how to get around this one. :? / comments
Hey Richard, your suggestion has prompted me to think about the time zones.
My local server is in US date format, but I am in Australia - the server I am trying to synchronize to is also in US date...
problem with comparing date column using dateadd and getdate
Hi everyone,
I run a comparison of two databases every day. I usually only check from a certain date (from yesterday) as usually there will be new entries from yesterday and a couple of changes onl...
Hi James - the screens I am using are the ones on the red-gate web site just so people know what part of the process I am talking about. My screens look just fine and all the functionality works as it should. However I just cannot scroll horizontally to see all of the columns! / comments
Hi James - the screens I am using are the ones on the red-gate web site just so people know what part of the process I am talking about. My screens look just fine and all the functionality works as...
Scroll bars in results window don't work!!!
Hi everyone - this one has me completely baffled.
Once SQL Data Compare finishes the comparison process between two databases it shows the results in the usual way, as in the example on the red-gat...