Sybase Adaptive Server Anywhere: Bin Directory and Utilities to Perform Import

SQLWays Wizard is able to execute the import process automatically. To perform it, user should provide target database credentials and Bin Directory.

Bin Directory is a path to a folder containing command line utility of the target database (like psql.exe, sqlcmd.exe, mysql.exe and others). With the help of this utility import process is performed.

So, during the import native utility connects to the target database using database credentials and tries to create all the objects that were converted by the tool.

It is extremely important to provide correct Bin Directory if we want to make an import. If a user doesn't have the appropriate utility on their local machine, it's necessary to install the DB client for a target database.

For Sybase SQL Anywhere database you need to specify the path to the folder on local machine that contains isql.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 the SAP official website.

If you have any other questions, please contact us: support@ispirer.com