Workaround for NullReferenceException in DBComparer

DBComparer 3.0 is a great tool if you want to synchronize your SQL Server database environments and don’t have hundreds of dollars to spend on Red Gate’s SQL Compare.  It’s simple to use and free.

I used it for a couple of weeks without any problem until one day when I tried to compare with a particular server and it crashed:

DBComparer NullReferenceException

Looking at the error message, we can deduce that the WriteRecentList() function saves the names of the servers you have typed in the recent servers list.  This is sort of like the recent files list found in some applications.

SettingsBase is part of the .NET Framework, and this part of the code is probably used to persist application settings.  A little digging around on the MSDN library reveals this:

Specific user data is stored in a file named user.config, stored under the user’s home directory. If roaming profiles are enabled, two versions of the user configuration file could exist. In such a case, the entries in the roaming version take precedence over duplicated entries in the local user configuration file.

A look in the user.config file confirms our theory that this is where the list of recent servers are stored.  However, DBComparer is only designed to support 10 recent server names (5 on each side of the comparison).  Any more than that and it blows up.

<?xml version="1.0" encoding="utf-8"?>
      <setting name="RecentServerName11" serializeAs="String">
      <setting name="RecentServerName12" serializeAs="String">
      <setting name="RecentServerName13" serializeAs="String">
      <setting name="RecentServerName14" serializeAs="String">
      <setting name="RecentServerName15" serializeAs="String">
      <setting name="RecentServerName21" serializeAs="String">
      <setting name="RecentServerName22" serializeAs="String">
      <setting name="RecentServerName23" serializeAs="String">
      <setting name="RecentServerName24" serializeAs="String">
      <setting name="RecentServerName25" serializeAs="String">

As a workaround until this bug is fixed, you can delete some or all of the server names in the value tags to make room for more and prevent the error.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s