Activity overview
Latest activity by kzakoski
CHM does not create any content in file
I've tried a number of different databases, small and large. I can successfully create HTML documentation. However, when I try to create the CHM documentation, it creates the compiled help file s...
I'm getting the exact same error in SQL Backup 5.1. The instances I'm trying to upgrade have 4.6 installed but I continue to get the
System.InvalidCastException: Object cannot be cast from DBNull to other types.
at System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider)
at System.Convert.ToInt32(Object value)
at _16._1(SqlConnection , _17 , Int32& , String& , Int32& )
at _16._1(SqlConnection , Int32& , String& )
at _16._1(Server , Int32& , String& )
at RedGate.SQLBackup.Engine.Server._10()
at RedGate.SQLBackup.Engine.Server.RefreshServerInformation()
at RedGate.SQLBackup.Engine.Server.OpenConnection()
when trying to make a connection to these instances from my 5.1 client. However, not all instances on this server get the error. The defualt and one instance on the same server upgraded without a problem.
The server these SQL Instances reside on is a Virtual server with 5 SQL instances, but the OS for this virtual instance is a 64 bit version, not 32. Not sure if this is the problem since two instances work just fine.
Kevin Z. / comments
I'm getting the exact same error in SQL Backup 5.1. The instances I'm trying to upgrade have 4.6 installed but I continue to get the
System.InvalidCastException: Object cannot be cast from DBNull ...
Tilman wrote:
Hi,
What elezar says is correct. The files should be quite self-explanatory.
Solution works with some tweaking. We experienced issues with the XML file format when pasting in code snippets in the main snippet xml file. Mixing ASCII and Unicode file formats didn't work, but once we realized what was happening we were able to add code snippets and share them between dev's.
As a future enhancement, it would be useful to have code snippets come from multiple sources versus one file. This would allow you to maintain your own customer snippets, but still have the ability to share a snippet file that contains common code that everyone could use. / comments
Tilman wrote:
Hi,
What elezar says is correct. The files should be quite self-explanatory.
Solution works with some tweaking. We experienced issues with the XML file format when pasting in c...
elezar wrote:
It looks like all of the config options are stored in XML files in the user's Local App Data folder. I haven't tried it, but I would imagine that you could copy those XML files and the options would all be copied.
The Local App Data folder for SQL Prompt is usually at %USERPROFILE%\Local Settings\Application Data\Red Gate\SQL Prompt 3
Thanks, I'll give it a try. / comments
elezar wrote:
It looks like all of the config options are stored in XML files in the user's Local App Data folder. I haven't tried it, but I would imagine that you could copy those XML files an...
Sharing option configuration
Is there a way to share the option configurations from one user to another in SQL Prompt 3?
SQL Refractor has the ability to save and load an option configuration and the same functionality would b...