Skip to Content

Problem Importing HANA Schema From one server to another

Hi all,

i'm experiencing problems importing HANA schema from one server to another server.

Both server have the same HANA Version 1.00.122.05.

I exported schema and data from first server from Hana Studio.

Now i'm trying to import schema in my test environment using import function of Hana Studio, but i'm gettng the following error.

Anyone has some hint? I've searched in SCN for similar error, but didn't find a solution.

I had similar error with another database schema too...it's not possible that should be so problematic export and import a schema from one server to another! In SQL Server it takes not more than 2 minutes without any problem!

Add comment
10|10000 characters needed characters exceeded

  • A schema export/import is not a backup/restore!

  • I know, just typed wrong because i was in hurry.

    Just wanted to say that can't be so problematic export and import a schema from database to another having the same appliance version.

    By the way this post doesn't answer to my question....have you got any hint?

    How can i have import a schema from one database to another for developing and testing purpose?

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 14 at 09:02 AM

    Solved.

    Had to import launching SQL statement for import because import from HANA Studio right clicking on catalogs and choosing "Import..." doesn't work.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 12 at 06:19 PM

    Check whether import happened correctly or not. There maybe possibility that Schema's are not properly imported from one server to other.

    Add comment
    10|10000 characters needed characters exceeded