Posted on March 2, 2016 by Wesley Surber

Avoiding the Chessbase Double-Upgrade Snare Part 2

Welcome to Part 2 of my series on merging the best of Chessbase, Chessbase Magazine, and the Big Database or Megabase! Yesterday’s post showed subscribers how to take the annotated games from CBM and insert them into your reference database to avoid having to upgrade your larger database each year with a secondary purchase from Chessbase. Today, we are going back into our reference database to perform some important housekeeping actions.

DISCLAIMER: As I stated before, it is important to always keep a backup of your data before starting any significant updates or modifications. This is especially true when messing with your reference database. I cannot be held liable if you’re chessbase software becomes a smoking hole in the ground from following these steps. However, if you experience trouble with the steps or have an easier way to perform these actions then please visit Campfire Chess on Facebook and leave comments on this article’s post sharing the details or send me a message on Twitter.

Now, let us begin!

Cleaning Up the New Database

  • So, our main goal here is to go into the reference database and to remove duplicate entries caused by installing the new games from the chessbase-magazin file.

  • To begin, left-click your reference database icon to select the database. This might take a few minutes depending on the size of your database and the speed of your computer as Chessbase processes its contents. Once the database is selected, click the Maintenance tab on the Chessbase ribbon.


The Maintenance tab on the main Chessbase screen. (Credit: Chessbase/Campfire Chess)

  • Next, click Find Double Games under the Improve group. This will bring up a new window that allows you to customize the database search for duplicate games. IT is extremely important that you exercise caution with this option because it can delete games from your database and create additional problems. The screen shot below shows the exact settings that I typically use for transferring games between databases.


The options dialog for finding duplicate games. (Credit: Chessbase/Campfire Chess)

Please take note of certain key settings:

  • Clip Doubles: I advise keeping this selected so that games removed from your reference database are transferred to the Chessbase Clip Database instead of being deleted completely. It makes for less of a headache if you suddenly realize that the program deleted games by mistake.
  • Merge Annotated Games: This is the safest way to get CBM games into your reference database and to keep them there. This option will merge any annotated game with a double occurrence of the same game that does not have annotations.
  • Remove Deleted Games: Use this option with caution because it will delete duplicate entries from your database and compact the database. The process will take awhile, especially if you are updating a large database like Megabase or Big Database.

So, what is the big deal with making sure that games are not deleted from the reference database? By making sure that the clip doubles option is selected, this will ensure that doubled games will be placed into the Chessbase clipboard database. this will allow the user to save the clipboard database as a separate database for future reference in the event that it is realized that games were removed from the reference database inadvertently.

And that…as they say…

…is that! Once the program has completed its sweep of the database, rebuilds the keys and search indexes, you are ready to move on with your newly updated reference database. This is a fantastic option for people who already own one of the Chessbase database options and subscribe to Chessbase Magazine. As I said in the intro, I absolutely love Chessbase, but there is no need for its users to pay twice for much of the same information. Of course, if you do choose to update via the Chessbase Shop, note that you will receive updates to the local Playerbase, which is not something that is updated through the method above.