SQL Migration tool for Database migration From MSSQL to SAP HANA Cloud Trail I am Getting Error

[former_member804841]

Hi Team,

We are using your SAP Advanced SQL Migration tool for Database migration From MSSQL to SAP HANA Cloud Trail. While we are using Tool we got this error. But the same database connected into the SQL Server Management Studio.

Please find the Attached file for your reference and give some solution for on this issue.

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

Since you're asking a question here for the first time, I'd like to recommend you with the following steps so you can get the most out of your community membership:

• Please see: https://community.sap.com/resources/questions-and-answers as this resource page provides tips for preparing questions that draw responses from our members
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,
-Alex

[Javier-Martin]

Hi can you please provide the following details:

- Gateway output window messages just after starting the gateway

- Full command line you are executing (you can replace details like password and hosts/ip's with meaningless names)

My feeling is that you are specifying a wrong ip somewhere, for example in the extract command you should provide the host/ip-address where the MSSQL server is listening and not the one for the gateway. The ip-address for the gateway should be specified in the config window your your project.

You may have some time to check details about that in the tutorial:

SAP Advanced SQL migration tool tutorial

Note: the tutorial is for Oracle, but gateway configuration is totally simliar.

PS: please can you please a "SAP Advanced SQL Migration" tag to your question, this is the specific tag for this tool.

Regards.

Javier.