The following is a quote from Baan Solution 131609 regarding upgrade of MS SQL Server 2000 from Level 1 to Level 2 Baan database driver. Does anyone know what the tool is that SSA Global are offering (or better still has anyone got something like it)? Many thanks.

"Migrating a system to Level II takes a great deal of time if the database is large and using the traditional Baan Tools method of bdbpre/bdbpost. In this scenario, each and every table would need to be dropped and recreated without the hash columns, the indexes rebuilt and each and every reference counter recalculated to ensure data integrity. Unless there is a significant window of opportunity for the system to be down this is not a viable option with a large database. Fortunately, SSA Global has come up with a methodology to expedite the conversion of data and avoid some of the steps involved with bdbpre/bdbpost.

We have already converted several customer systems in a weekend (starting Friday) via this method and they are successfully running with this configuration today. We are seeing throughput rates on the conversion of the tables of nearly 4 Gig an hour. This is 2 to 3 times faster than data loads with bdbpre and bdbpost, not to mention the time it takes to repair the reference counters. "

The tool migrates the DB inline, its only available from SSA in conjunction with a service.

Dave

This is a utility which comes free with the Baan V installation CD's. You can do this yourself, export all the data and tools tables. Then make changes to tbledef6.1 (Refer to documents on setting for LEVEL 2 driver available from Baan) :

ppmmm999:*:msql7(MSQL_LEVEL1=0, MSQL_SERVERHOST=.):Y
for example :
tpptc000:*:msql7(MSQL_LEVEL1=0, MSQL_SERVERHOST=.):Y


After doing this import tools data back and make sure everything is working.

Then import all other baan data back, and you have migrated from LEVEL1 driver to LEVEL2 driver.

Latest Update :
(from 567146_Technical_Notes_Portingset_61c0713.pdf)

Microsoft SQL Server
--------------------
Supported:

�� SQL Server 2000, 2005
Enterprise Edition, Standard Edition
Workgroup Edition in combination with Windows 2003 Small Business
Server.

�� SQL Server 2000 SP3a, SP4

�� SQL Server 2005 SP1

Level 2 is supported with SQL Server 2000 and 2005 for SSA Baan IVc4.
To enable the driver:

a) Install solution 142802.

b) Run correction program ottcormsql.

c) Click Activate MSQL Server Level II in the Maintain Requested System
Configuration (ttadv0145m000) session and request a new license key

SQL Server 2005
----------------

If you migrate to SQL Server 2005, make sure to install SQL_DMO as part of
the SQL Server 2005 installation, because BaanIV requires this module for
SQL Server administration.