![]() ![]() The script that is provided and used to create the Oracle user and data model in step 1 can be used for this purpose as well.Ĭopy that script ( APPDEMO2.sql) to the Windows host where the migration tool is running, for example, under folder c:\sql_scripts\APPDEMO2.sql. When each of those 2 popup windows appears just read and click on I confirm, then rerun the command again (you will have to rerun the command twice the first time).Įxtract using text file containing object definitions (OPTIONAL)īefore proceeding with this optional step you have to delete subfolder called extracted under the project folder, it was generated when running extract option with the Gateway and will generate it again now When you execute the extract option for the first time in a new project folder you will get 2 popup windows to confirm that compliance with 3rd party rights has been verified. IMPORTANT: windows firewall or antivirus software can prevent the migration tool connecting to the gateway, if you have connectivity issues try stopping/configuring firewall/antivirus ![]() NOTE: the Oracle user you specify for this command needs to have read permissions on the catalogs, it will not perform any modification in the source database, SELECT_CATALOG_ROLE is enough for this purpose. Once the gateway is up and running execute the migration tool utility sapdbmtk with extract option, the command line parameters you have to specify are:Ĭ://sapdbmtk 32# sapdbmtk extract C:/tmp/Advanced_SQL_Mig_tutorial 1521 You are ready to run the migration tool extract command. The bindaddress should be the ipadress/ hostname for the host where the migration tool is installed, and the port should be the one you have specified in configuration setting with ID #111 (12345 as specified in step number 2). Open config.properties file under c:\sapdbmtk\gateway folder and modify lines 4 and 5 as described in the picture below. You are going to configure and start the gateway now. ![]() The migration tool gateway is usually executed in a separate host, but for simplicity in this tutorial it will be executed in the same host where the migration tool is installed, notice that Java version 1.8 minimum is required to run the gateway. IMPORTANT: It is recommended for you to try both methods, go through the gateway first in section 1 and then go through optional steps in section 2 Extract using the migration tool gateway Then section 2 is optional, do it if you want to see the extraction using a text file as well. Section 1 is mandatory and you will go through the extraction via the migration tool gateway. The project folder is configured now, and a subfolder called config is created.ĭata model and SQL objects extraction can be done either by connecting to the source database via the migration tool gateway or using text files with object definitions (DDLS). ID # 754 > SAP HANA user password for user specified in previous parameterĬlick Validate
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |