Question about replication from MS SQL-Server to HANA with SLT

[Former Member]

Hi,

I'm trying to replicate some tables from an MS SQL Server DB to a HANA system via SLT. Replication can be configured without a problem but I am not very happy with the result in HANA.

Here is an example of a table in SQL Server:

This is the replicated table in the HANA system:

Well, all fields are there and probably no data would be lost, but there are several things which seem very strange.

1) The numeric fields have all length 31

2) All fields have the attribute "NOT NULL", in the source table this was only set for BAS_ID

3) The order of the fields is different

Is this behaviour normal? Thx for any hints.

  Best regards

    Harry

[candy_zhan]

Hi Harry,

It does not look normal. What is your DIMS version? Have you implemented all the correction notes?

Best regards,

Candy Zhan

[Former Member]

Hi Candy,

the DMIS version is 2011_1_700 with SP 08, I did not find anything newer. Notes should be in, but I check to make sure that I did not miss one.

Best regards

   Harry

[Former Member]

Hi,

well, some correction notes for SP08 were missing. Mea culpa 🙂 Unfortunately implementation of the notes did not solve all Problems. Now the field length is correct but the field order and "not null"-Status of the fields is still wrong.

Best regards

  Harry