Comments
Sort by recent activity
Ok. Thanks. I'm an idiot. I have never clicked on the ... to browse for a folder - thus I never saw that checkbox option, nor did I think to put the <database> variable in the Backup folder.
I didn't think that the "backup folder" could be "variable-ized". I was thinking that only the "file name format" had that feature.
Thanks again! / comments
Ok. Thanks. I'm an idiot. I have never clicked on the ... to browse for a folder - thus I never saw that checkbox option, nor did I think to put the <database> variable in the Backup folder.
I d...
Jason C.,
Thanks I got it. I assumed that the Red-Gate utilities page was the latest version.
The 5.1 version worked just fine. Wag of the finger to RG for not posting the most current version on the website! [image] / comments
Jason C.,
Thanks I got it. I assumed that the Red-Gate utilities page was the latest version.
The 5.1 version worked just fine. Wag of the finger to RG for not posting the most current version on...
I have a *.sqb file backed up that I want to restore to a SQL Server that doesn't have SQLBackup installed.
I have tried the backup both with and without encryption, but I get the same error.
Error converting file: ZLib decompression error: data error
Backup details:
compression level: 2
Threads: 3
encryption: tried both with and without.
I am using the sqb2mtf.exe from: http://downloads.red-gate.com/sqb2mtf.zip
located on the utilities page. http://www.red-gate.com/support/downloa ... lities.htm
I'm at a loss. Any insight would be much appreciated. / comments
I have a *.sqb file backed up that I want to restore to a SQL Server that doesn't have SQLBackup installed.
I have tried the backup both with and without encryption, but I get the same error.
Error...
Just as lifecDBA experienced, the GUI version worked for me, but the command line version did not.
GUI: http://labs.red-gate.com/index.php/SQL_ ... _Converter
Is the GUI version using different code? Is there just a bug in the command line version? / comments
Just as lifecDBA experienced, the GUI version worked for me, but the command line version did not.
GUI: http://labs.red-gate.com/index.php/SQL_ ... _Converter
Is the GUI version using different cod...
@Error block and the BEGIN/END TRAN's
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
IF EXISTS(SELECT * FROM sysobjects WHERE name = <PROC>)
DROP PROCEDURE <PROC>
GO
/*
** Desc: <DESC>
** Auth: <AUTH>
** Date: <DATE>
*/
CREATE PROCEDURE <PROC>
@UserID INT
AS
BEGIN TRAN
SELECT 1
IF @@ERROR <> 0
BEGIN
ROLLBACK TRAN
RAISERROR('An error occurred while trying to <DO SOMETHING> in stored procedure <PROC>.', 16, 1)
RETURN
END
COMMIT TRAN
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
/ comments
@Error block and the BEGIN/END TRAN's
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
IF EXISTS(SELECT * FROM sysobjects WHERE name = <PROC>)
DROP PROCEDURE <PROC>
GO
/*
**...
SELECT INTO...
/*
** SELECT ... INTO
** Creates a new table in DestDB and populates it
** with data from SrcDB..SrcTable
*/
SELECT *
INTO DestDB..NewTable
FROM SrcDB..SrcTable
INSERT SELECT
/*
** INSERT ... SELECT
** Inserts records into an existing table.
*/
INSERT INTO DestinationTable
SELECT Field, Field2
FROM OtherTable
WHERE clause
/ comments
SELECT INTO...
/*
** SELECT ... INTO
** Creates a new table in DestDB and populates it
** with data from SrcDB..SrcTable
*/
SELECT *
INTO DestDB..NewTable
FROM SrcDB..SrcTable
INSERT SELECT
/*
** ...
Thanks for your quick response to my feedback.
Let me make one more request. I really miss the color coding of the differing lines when viewing each object's text. I am speaking of SqlCompare v3 because I never used v4.
The subdued colored arrows indicating the lines that have changed or that differ just don't catch my eye, and I have to scan for them.
<soapbox>
One could certainly argue that color coding can easily be done poorly, and that even when done correctly it detracts from the beauty of the screen. To me the beauty is the ability for me to find what I need quickly (finding changes by line) and get done what I need to get done and then get on with my other tasks.
</soapbox> Version 3 (You can find the lines that differ immediately) [image] Version 5 (I almost miss the lines that differ) [image] / comments
Thanks for your quick response to my feedback.
Let me make one more request. I really miss the color coding of the differing lines when viewing each object's text. I am speaking of SqlCompare v3 ...
What's "usability testing" Those users don't know what's good for them! [image] hahah just kidding.
Were your initial colors somewhat bold or were they more subdued? The colors that I chose were extreme for sure.
Well if I lose out to the majority, at least let me plea for an application option to "colorize group bars" - with the default set to "off" of course.
While I'm at it, let me also ask for some additional font options for viewing the object text. Lucida Console is OK, but I'm more of a Courier New kind of guy. How about an application option for object text font:
-Lucida Console
-Courier New
-Courier
By the way, I love the font size options right there in the bottom panel.
Regarding the scrollbar inside the group - if you have a large number of items in a group, when you scroll down, you lose the group context in which you are in. If you have all groups expanded, when you scroll up and down globally, you may whiz by a group header and then you don't know which group you are in (because all group headers are gray [image] ). With the scrollbar contained within the group, the group header is always visible (kind of like freeze panes in Excel) and you always maintain context. / comments
What's "usability testing" Those users don't know what's good for them! hahah just kidding.
Were your initial colors somewhat bold or were they more subdued? The colors that I chose were extrem...
I failed to fully document my process, but I loaded a sample project in VS 2010. It upgraded OK. I ran it, and I updated the references to my install folder and set the target to .Net 2.0. I can't remember if it built without errors or not, but I do know that it never prompted me for a serial #.
Back to my own project. I still get the same error as before. If I target .Net 2.0 on my project it builds and runs, but if I change the target back to .net 4.0 or 4.0 Client, it gives the same "Unable to resolve type..." error as before.
Is there any chance of getting the licensing client updated to .Net 4.0? And the sample projects with it? .Net 4.0 is a solid 2 years old now... 8) / comments
I failed to fully document my process, but I loaded a sample project in VS 2010. It upgraded OK. I ran it, and I updated the references to my install folder and set the target to .Net 2.0. I can...