Do you know about B1DE and its tools?

A new version has been submitted in SDN, this version will fix some bugs existing on previous versions like:

• Fix authorization problem for UDO classes generation on Code Generator Wizard.
  Version 2.0 exposed a new feature for UDOs giving you the possibility to autogenerate a class for a UDO. This feature had a limitation on version 2.0 due to authorizations needed to execute the generated class (cf blog Non Super Users and B1DE version 2.0 UDO classes).
• Fix bug on UDO class generation for a UDO without child tables (an exception was thrown and the class was not generated)
• Fix problem with User Defined Fields of type Float and Date creation through the Code Generator (an exception was raised as size was wrong, no size is needed)
• A new format has been defined to provide the Db Changes between different SAP Business One versions. The DbBrowser now includes the new files provided for versions up to SAP Business one 2007 version and is able to read this new format.

Do you know more concretely about B1DbBrowser tool?
And its capability to read the DbChangesList files given per each SAP Business One release?

B1DbBrowser is a tool included in the B1DE (Development Environment) tools package. This tool visualizes the current status of a SAP Business One database in terms of the tables currently defined, their columns, and properties – such as name, type, default values and database constraints. It can be started from the B1 Code Generator Wizard or directly executed as a Windows application.

One of the specifc features of this tool is to be able to read the DbChangesList files given per each SAP Business One release and show the tables that are new or modified together with the specific fields or keys modified in each table.
In order to see the DbChangesList corresponding to a specific SAP Business One version just go to the ToolBar of the B1DbBrowser, select the DBChanges menu button in the top right part and finally select the version you want to see the differences regarding its previous version (ex: if you select 2007 you will see the differences between 2007 and 2005 SP01 databases versions). Please not the DbChanges are obtained from a fixed xml file and doesn't depend on the database you are connected to.

Just have a look to the following screen capture to see how the information is presented by B1DbBrowser:

"

As the format of the DbChangesList files has changed to provide more accurate information B1DBrowser has been adapted to be able to read the new files for versions starting from SAP Business One 2007. Go and download the new version of the B1DE package (2.0.1) from the SDK Tools page and have a look at this tool.