Ispirer Ispirer
 


Ispirer Home Page Request SQLWays

Utilities That Are Used In MnMTK To Perform Import

When migrating from one database into another database using SQLWays Wizard tool, it is possible to execute the import process automatically. To do that you need to know about the utilities that will be used to execute import process.

SQLWays Wizard generates a .bat script for each converted object. In such a script you can find a command to the utility that will be used to perform import process. During import process the tool just runs this command to the native utility and then the utility itself connects to the target database and tries to import the converted sql code into the target database.

For each target database SQLWays Wizard generates commands to different native utilities. Please also note that SQLWays Wizard doesn't use any third-part tools or utilities to perform import. It generates commands only for native utilities of the target database that are provided by the RDBMS vendors.

In order to generate correct command lines to the required utilities we need to provide a path to the folder that contains required utilities in the “Bin Directory” option. This option can be found on the “Specify Import Options” page of SQLWays Wizard Tool:


Below you can find the information about different databases and native utilities that will be used by SQLWays Wizard tool and where you can find them.

Databases and Utilities

Oracle

To perform import into Oracle database in the Bin directory Option we need to specify a path to the folder which contains sqlldr.exe and sqlplus.exe utilities. By default these utilities are located in the directory like: c:\app\[user_name]\product\[DB_Version]\client_1\BIN\. Otherwise you can find them in the directory specified during the installation process of Oracle database.

If there are no such utilities on the machine where migration process will take place, it means that you need to install the Oracle Client. You can download the Oracle client from Oracle official website using this link: Download Oracle Client.

Please note that you need to choose “Administrator” installation type of the client to get all the required utilities installed on your machine.

Ispirer Note:
To be able to perform import into Oracle you have to tune the TNS service name and provide this name on the “Choose a Target Database” page of SQLWays Wizard tool. You can learn how to tune the TNS name in this article: How to Tune the TNS Service Name For Oracle

Microsoft SQL Server

For Microsoft SQL Server you need to specify a path to the folder that contains bcp.exe and sqlcmd.exe native utilities. By default these utilities are located in the directory like: c:\Program Files\Microsoft SQL Server\[DB_Version]\Tools\Binn\. Otherwise, you can find them in the directory specified during the installation process of Microsoft SQL Server database. You can also check the location of these utilities in the Management Studio installation directory.

If there are no such utilities on the machine where migration process will take place, it means that you need to install the Microsoft SQL Server Client. You can download it from Microsoft official website using this link: Download SQL Server Client.

Azure SQL Data Warehouse

For Microsoft SQL Data Warehouse you need to specify a path to the folder containing bcp.exe and sqlcmd.exe native utilities. By default these utilities are located in the directory like: c:\Program Files\Microsoft SQL Server\[DB_Version]\Tools\Binn\. Otherwise, you can find them in the directory specified during the installation process of Microsoft SQL Server database. You can also check the location of these utilities in the Management Studio installation directory.

If there are no such utilities on the machine where migration process will take place, it means that you need to install the Microsoft SQL Server Client. You can download the SQL Server client from Microsoft official website using this link: Download SQL Server Client.

Azure SQL Database

For Microsoft Azure SQL Database you need to specify a path to the folder containing bcp.exe and sqlcmd.exe native utilities. By default these utilities are located in the directory like: c:\Program Files\Microsoft SQL Server\[DB_Version]\Tools\Binn\. Otherwise, you can find them in the directory specified during the installation process of Microsoft SQL Server database. You can also check the location of these utilities in the Management Studio installation directory.

If there are no such utilities on the machine where migration process will take place, it means that you need to install the Microsoft SQL Server Client. You can download the SQLServer client from Microsoft official website using this link: Download SQL Server Client.

IBM DB2

For IBM DB2 database you need to specify a path to the folder containing db2.exe native utility. By default this utility is located in the directory like: c:\Program Files (x86)\IBM\SQLLIB\BIN\. Otherwise, you can find it in the directory specified during the installation process of DB2 Data Server Client.

If there is no such utility on the machine where migration process will take place, it means that you need to install the DB2 Data Server Client. You can download it from IBM official website: https://www.ibm.com.

IBM Informix

For Informix database you need to specify a path to the folder containing dbaccess.exe native utility. By default this utility is located in the directory like: c:\Program Files (x86)\Informix Client-SDK\bin\. Otherwise, you can find it in the directory specified during the installation process of Informix SDK Client.

If there is no such utility on the machine where migration process will take place, it means that you need to install the Informix SDK Client. You can download it from IBM official website: https://www.ibm.com.

IBM Netezza

For Netezza database you need to specify a path to the folder containing nzsql.exe native utility. By default this utility is located in the directory like: C:\\Program Files (x86)\\IBM Netezza Tools\\Bin\. Otherwise, you can find it in the directory specified during the installation process of IBM Netezza Client.

If there is no such utility on the machine where migration process will take place, it means that you need to install the IBM Netezza Client. You can download it from IBM official website: https://www.ibm.com.

MySQL

For MySQL database you need to specify a path to the folder containing mysql.exe native utility. By default this utility is located in the directory like: c:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\. Otherwise, you can find it in the directory specified during the installation process of MySQL database.

If there is no such utility on the machine where migration process will take place, it means that you need to install the MySQL Workbench. You can download the MySQL Workbench from MySQL official website using this link: Download MySQL Workbench.

MariaDB

For MariaDB database you need to specify a path to the folder containing mysql.exe native utility. By default this utility is located in the directory like: c:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\. Otherwise, you can find it in the directory specified during the installation process of MySQL Workbench.

If there is no such utility on the machine where migration process will take place, it means that you need to install the MySQL Workbench. You can download the MySQL Workbench from MySQL official website using this link: Download MySQL Workbench.

Amazon Aurora (MySQL Compatible)

For Amazon Aurora database you need to specify a path to the folder containing mysql.exe native utility. By default this utility is located in the directory like: c:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\. Otherwise, you can find it in the directory specified during the installation process of MySQL Workbench.

If there is no such utility on the machine where migration process will take place, it means that you need to install the MySQL Workbench. You can download the MySQL Workbench from MySQL official website using this link: Download MySQL Workbench.

PostgreSQL

To perform import into PostgreSQL database in the Bin directory option we need to specify a path to the folder containing psql.exe utility. By default this utility is located in the directory like: c:\Program Files (x86)\PostgreSQL\[version_number]\bin\. Otherwise, you can find it in the directory specified during the installation process of PGAdmin tool.

If there is no such utility on the machine where migration process will take place, it means that you need to install the PGAdmin tool. You can download it from PostgreSQL official website using this link: Download PGAdmin Tool.

EnterpriseDB

To perform import into EnterpriseDB database in the Bin directory option we need to specify a path to the folder containing psql.exe utility. By default this utility is located in the directory like: c:\Program Files (x86)\PostgreSQL\[version_number]\bin\. Otherwise, you can find it in the directory specified during the installation process of PGAdmin tool.

If there is no such utility on the machine where migration process will take place, it means that you need to install the PGAdmin tool. You can download it from PostgreSQL official website using this link: Download PGAdmin Tool.

Greenplum

To perform import into Greenplum database in the Bin directory option we need to specify a path to the folder containing psql.exe utility. By default this utility is located in the directory like: c:\Program Files (x86)\PostgreSQL\[version_number]\bin\. Otherwise, you can find it in the directory specified during the installation process of PGAdmin tool.

If there is no such utility on the machine where migration process will take place, it means that you need to install the PGAdmin tool. You can download it from PostgreSQL official website using this link: Download PGAdmin Tool.

Amazon Redshift

To perform import into Redshift database in the Bin directory option we need to specify a path to the folder containing psql.exe utility. By default this utility is located in the directory like: c:\Program Files (x86)\PostgreSQL\[version_number]\bin\. Otherwise, you can find it in the directory specified during the installation process of PGAdmin tool.

If there is no such utility on the machine where migration process will take place, it means that you need to install the PGAdmin tool. You can download it from PostgreSQL official website using this link: Download PGAdmin Tool.

Amazon Aurora (PostgreSQL Compatible)

To perform import into the Aurora database in the Bin directory option we need to specify a path to the folder containing psql.exe utility. By default this utility is located in the directory like: c:\Program Files (x86)\PostgreSQL\[version_number]\bin\. Otherwise, you can find it in the directory specified during the installation process of PGAdmin tool.

If there is no such utility on the machine where migration process will take place, it means that you need to install the PGAdmin tool. You can download it from PostgreSQL official website using this link: Download PGAdmin Tool.

SAP HANA

For Sap Hana database you need to specify the path to the folder on local machine that contains hdbsql.exe native utility. By default this utility is located in the directory like: C:\\Program Files\\sap\\hdbclient\. Otherwise, you can find it in the directory specified during the installation process of Sap Hana HDB Client.

If there is no such utility installed on local machine, where migration process will take place, it means that you need to install the HDB Client. If you don't have installation packages, you can download the Sap Hana HDB Client installation package from SAP HANA official website using this link: Download Sap Hana HDB Client.

Sybase SQL Anywhere

For Sybase SQL Anywhere database you need to specify the path to the folder on local machine that contains dbisql.exe utility. By default this utility is located in the directory like: c:\Program Files (x86)\Sybase\[SQL_Anywhere_Version]\win32\. Otherwise, you can find it in the directory specified during the installation process of Sybase SQL Anywhere Client.

If there is no such utility installed on local machine, where migration process will take place, it means that you need to install the Sybase SQL Anywhere Client. If you don't have installation packages, you can download the required installation package from SAP official site using this link: Download Sybase SQL Anywhere Client.

Sybase Adaptive Server Enterprise

For Sybase ASE database you need to specify the path to the folder on local machine that contains isql.exe and bcp.exe utilities. By default these utilities are located in the directory like: s:\DBClients\SybaseASE12_5\OCS-12_5\bin\. Otherwise, you can find them in the directory specified during the installation process of Sybase PC Client or Sybase SDK.

If there are no such utilities installed on local machine, where migration process will take place, it means that you need to install the Sybase PC Client or SDK for Sybase for latest versions. If you don't have installation packages, you can download the required installation package from the Sap Software Download Center using this link: Sap Software Download Center.

Sybase IQ

For Sybase IQ database you need to specify the path to the folder on local machine that contains dbisql.exe utility. By default this utility is located in the directory like: C:\sybaseIQ\[DB_Version]\Bin64\. Otherwise, you can find it in the directory specified during the installation process of Sap IQ Client Software.

If there is no such utility installed on local machine, where migration process will take place, it means that you need to install the Sap IQ Client Software. If you don't have installation packages, you can download the required installation package from Sap Software Download Center using this link: Sap Software Download Center.

Teradata

For Teradata database you need to specify the path to the folder containing bteq.exe and fastload.exe native utilities. By default these utilities are located in the directory like: c:\Program Files (x86)\Teradata\Client\15.00\bin\. Otherwise, you can find it in the directory specified during the installation process of Teradata Tools and Utilities package.

If there are no such utilities installed on local machine, where migration process will take place, it means that you need to install them. If you don't have installation packages for bteq.exe and fastload.exe, you can download the TTU (Teradata Tools and Utilities) package from Teradata official website using this link: Download Teradata Tools and Utilities Package. You need to open this archive and run the installation of the required utilities only.


Ispirer Home Page Request SQLWays

sqlways/faq/utilities-to-make-import.txt · Last modified: March 22, 2019, 12:14:02 PM by darya.prikhodkina
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement