Skip to Content
avatar image
Former Member

System copy from SQL2000 to SQL2005

Hello All,

We are trying to perform a homogenous system copy. Our source system is SQL 2000 and the target system is SQL 2005. We followed the normal attach/detach procedure and ran the STM tool for the database copy. After bringing SAP online, it gives an consistency check error in SICK - "Wrong long datatypes. Perform SQL2005 after upgrade steps. Please see note 126973."

This note in turn refers to note 799058 which describes the procedure of upgrading to SQL 2005 and homogenous system copy. But we have already done that. Can somebody please help me on this and let me know what I am missing.

Thanks,

Fahad

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 04, 2007 at 12:02 PM

    Hi,

    SICK generally gives error for Kernel issues. Perform a kernel upgrade.

    Do not forget to download the latest DB dependent files for MSSQL 2005

    And let us know how it goes.

    Regards,

    Siddhesh

    Add comment
    10|10000 characters needed characters exceeded