Comments
Sort by recent activity
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...