EnterpriseDB: Bin Directory and Utilities to Perform Import

To perform the import process automatically, the SQLWays Wizard must be provided with the credentials of the target database and the Bin Directory.

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

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

For import performing it is important to provide correct Bin Directory. 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 EnterpriseDB as target database in the Bin directory option we need to specify a path to the folder containing psql.exe utility. By default it could be the directory like: C:\Program Files (x86)\PostgreSQL\[version_number]\bin\. Otherwise, you can find it in the directory which was specified during the installation process of PGAdmin tool: C:\Users\user.name\AppData\Local\Programs\pgAdmin 4\v6\runtime.

If this utility is not available on the computer where the migration process will take place it means that you need to install the PGAdmin tool. You can download it from the PostgreSQL official website.

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