Hi,

Need to get rid of creation of the hash field and indexing of the field by BaaN.
As I understand that these can be achieved by converting the data from level 1 to level 2.

Do we need to carry out the data level conversion at DB level?
Can anyone pls tell us the procedure of converting the level 1 data to level 2?

Thanks in advance.

Hello skr,

you do the conversion at Baan level.

The steps are:
- make sure that your portingset supports L2 (has to be 6.1c.07.04 or newer)
- make sure that you have a license that includes MS SQL L2
- bdbpre all data (Create seq. Dump of Table)
- change db_resource: mssql_level1:0
- bdbpost all data (Create Table from seq. dump).


Good luck.

Lebowski

I agree with Lebowski.

One alternative though, if you find that you can't export/import in a reasonable amount of time - is to use Infor's Level 2 conversion service. They convert the database inline which is usually significantly faster than if you were to do the export/import method.

Dave

Hi Lebowsky / Dave-23,

Thank you guys for your prompt response.
I immediately tried out the steps provided by Lebowsky and confirmed by Dave.

Following is what I did:
1. Took sequential Dump.
2. Changed db_resource to: msql_level1:0
3. Changed the tabledef6.1 from msql_level1:1 to mssql_level1:0 using ttaad4110m000.
4. created tables from sequential dump.
5. Exit baan.

Then when I tried to login, it is giving error : ERROR 515 (LICENSE ERROR) ON SELECT - CANNOT CONTINUE IN ottstpstdlib (mess).

Then on manually changing the tabledef6.1 file to the earlier mssql_level1:1, baan starts working. But all the tables are having hash as usual.

Thus we are back to the earlier state.
Any further suggestion(s)? What can be the cause of the error?

best wishes,

SKR

Hi,

you missed step 2:


- make sure that you have a license that includes MS SQL L2


You have to get a new licence key with the commercial function "MS SQL L2".
Check Solution 142802.

Have a nice day,

Lebowski