Comments
Sort by recent activity
I was going through a series of snapshots, kept getting interrupted and had to keep checking to see which one I was on.
Thanks,
Traci / comments
I was going through a series of snapshots, kept getting interrupted and had to keep checking to see which one I was on.
Thanks,
Traci
Another reason - it would also make the snapshot "status" stand out a little more than just the camera icon. I'm usually working with live development or test servers, but I've sometimes come back to SQL Compare after being interrupted, glanced at the Server and Database names to reorient, panicked that I had inadvertently accessed a live production database, clicked Edit Project to change it and realized it was a snapshot of production because the Snapshot Source/Target entry pane is very different than the Database one. / comments
Another reason - it would also make the snapshot "status" stand out a little more than just the camera icon. I'm usually working with live development or test servers, but I've sometimes come back ...
I'm still having this problem even on the latest cumulative patch. [image]
Thanks,
Traci / comments
I'm still having this problem even on the latest cumulative patch.
Thanks,
Traci
I installed the cumulative patch and the SQL Data Compare launch button is still grayed out. I tried an existing project and creating a new project.
Thanks.
Traci
SQL Compare 8.2.1.49 / comments
I installed the cumulative patch and the SQL Data Compare launch button is still grayed out. I tried an existing project and creating a new project.
Thanks.
Traci
SQL Compare 8.2.1.49
That worked perfectly - thank you!
I'm copying the code I used from the article and the comments, if anyone else needs it: CREATE FUNCTION [dbo].GetTicksFromTime (@d datetime)
RETURNS BIGINT AS BEGIN
RETURN (DATEDiff(s, '20060823', @d) + 63291888000 ) * 10000000
END
GO
CREATE FUNCTION dbo.GetTimeFromTicks (@Ticks BIGINT)
RETURNS DATETIME AS BEGIN
DECLARE @Days BIGINT
DECLARE @DaysBefore1753 BIGINT
DECLARE @TimeTicks BIGINT
DECLARE @Seconds BIGINT
SET @Days = @Ticks / CONVERT(BIGINT,864000000000)
SET @DaysBefore1753 = CONVERT(BIGINT,639905)
SET @TimeTicks = @Ticks % CONVERT(BIGINT,864000000000)
SET @Seconds = @TimeTicks / CONVERT(BIGINT,10000000)
RETURN DATEADD(s,@Seconds,DATEADD(d,@Days - @DaysBefore1753,CONVERT(DATETIME,'1/1/1753')))
END
GO
DECLARE @TestDate datetime
SET @TestDate = GETDATE()
select @TestDate, dbo.GetTicksFromTime(@TestDate), dbo.GetTimeFromTicks(dbo.GetTicksFromTime(@TestDate))
SET @TestDate = '2/29/1992 12:34:56'
select @TestDate, dbo.GetTicksFromTime(@TestDate), dbo.GetTimeFromTicks(dbo.GetTicksFromTime(@TestDate))
GO
/ comments
That worked perfectly - thank you!
I'm copying the code I used from the article and the comments, if anyone else needs it:CREATE FUNCTION [dbo].GetTicksFromTime (@d datetime)
RETURN...
Our databases use schemas extensively. Searching for schema.object is producing many invalid hits because SQL Search is ignoring the dot. Is there a patch coming for this anytime soon?
Thanks,
Traci / comments
Our databases use schemas extensively. Searching for schema.object is producing many invalid hits because SQL Search is ignoring the dot. Is there a patch coming for this anytime soon?
Thanks,
Traci
I was wondering why SQL Search was giving me false positives. Having the "." is critical when working with schemas. Is there an ETA on a patch for this?
Thanks,
Traci / comments
I was wondering why SQL Search was giving me false positives. Having the "." is critical when working with schemas. Is there an ETA on a patch for this?
Thanks,
Traci
That works great! Any chance we could get a "Copy with Headers" for the right-mouse menu? It currently has Copy and Select All.
Thanks,
Traci / comments
That works great! Any chance we could get a "Copy with Headers" for the right-mouse menu? It currently has Copy and Select All.
Thanks,
Traci
I'd like to add my vote for the ability to save a snapshot of either side from the main compare window. / comments
I'd like to add my vote for the ability to save a snapshot of either side from the main compare window.
Thanks for the additional information. Mostly I dislike having to go to another window and re-type the server and database name when I'm looking right at it on the compare screen. Especially if I decide I want a snapshot of both sides. / comments
Thanks for the additional information. Mostly I dislike having to go to another window and re-type the server and database name when I'm looking right at it on the compare screen. Especially if I d...