Comments
Sort by recent activity
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...
Thank you for for reference to the KB article, however it is insufficient for two reasons.
1) The Restore wizard (or something) appends a hard coded "\Data" to the end of my specified location. Ex: I put "D:\SqlData" in the registry, but the Restore Wizard shows "D:\SqlData\Data".
2) No separate entry for default log location. My data files and log files are on different logical (and physical) drives - as recommended by everybody who knows anything about SQL internals and hardware.
#2 is a bummer. If #1 worked, this would solve at least 1/2 of my pain-point, but because #1 the registry hack is totally useless to me.
From a philosophical standpoint, why would the tool simply ignore any meaningful configuration set by the user? I argue that the tool should pull the default Data and Log locations from the server instance configuration. After all, SQL Server uses it when creating new databases. If it's good enough for SQL, why not Red-Gate? / comments
Thank you for for reference to the KB article, however it is insufficient for two reasons.
1) The Restore wizard (or something) appends a hard coded "\Data" to the end of my specified location. Ex...
Yes! I get
"D:\SqlData" and "E:\SqlLogs"
What is 1012? A hidden/undocumented feature? / comments
Yes! I get
"D:\SqlData" and "E:\SqlLogs"
What is 1012? A hidden/undocumented feature?
I have a similar error. One of my databases compare just fine, but most give the following error when registering the 2nd (and remote) database: Unable to cast object of type 'System.DBNull' to type 'System.String'.
Verbose log file... 00:21:37.488|Info |Logging |1 |Current Logging levels enabled: Verbose,Warning,Fatal,Debug,Information,Trace,Error
00:21:52.301|Error |Engine Service |1 |:Exception in progress dialog
System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
at r.i()
at r.b()
at RedGate.MySQL.ObjectModel.Population.LivePopulator.Populate()
at RedGate.MySQL.ObjectModel.Population.DatabasePopulationHelper.a(IPopulator )
at RedGate.MySQL.ObjectModel.Population.DatabasePopulationHelper.PopulateDatabase2()
at RedGate.Shared.Controls.ProgressDialogEx.e()
/ comments
I have a similar error. One of my databases compare just fine, but most give the following error when registering the 2nd (and remote) database:Unable to cast object of type 'System.DBNull' to typ...