Re: regarding schema only migration from sqlserver to postgres with runmtk.sh - Mailing list pgsql-general

From Durgamahesh Manne
Subject Re: regarding schema only migration from sqlserver to postgres with runmtk.sh
Date
Msg-id CAJCZkoJ5coYtrGwnODay48zZYtQ1YafWUEs3viRrVJ0EWKVFeQ@mail.gmail.com
Whole thread Raw
In response to Re: regarding schema only migration from sqlserver to postgres with runmtk.sh  (Jan de Visser <jan@de-visser.net>)
Responses Re: regarding schema only migration from sqlserver to postgres with runmtk.sh
List pgsql-general
as per above conversation. i checked connectivity details as it is connected to database  (even hostname i mentioned connected to database)
  psql --host 192.168.168.201 --user postgres -d raghu
Password for user postgres:
psql.bin (9.4.8, server 9.4.4)
Type "help" for help.

No entry for terminal type "xterm";
using dumb terminal settings.
raghu=#


On Thu, Jun 16, 2016 at 8:51 PM, Jan de Visser <jan@de-visser.net> wrote:
Please don't top-post.

On Thursday, June 16, 2016 8:30:53 PM EDT Durgamahesh Manne wrote:
> hi
> sir
> as per above discussion same error repeated even mentioned ip address of
> hostname
>
> ./runMTK.sh -sourcedbtype sqlserver -targetSchema public -schemaOnly
> -allTables dbo
>
>
> TARGET_DB_URL=jdbc:postgresql://192.168.168.201:5432/raghu
> TARGET_DB_USER=postgres
> TARGET_DB_PASSWORD=*****
>
>
>
> Connecting with source SQL Server database server...
> Connected to Microsoft SQL Server, version '10.50.1600'
> Connecting with target EnterpriseDB database server...
> MTK-10045: The URL specified for the "target" database is invalid.
> Check the connectivity credentials.
> Stack Trace:
> com.edb.MTKException: MTK-10045: The URL specified for the "target"
> database is invalid.
> Check the connectivity credentials.
>

So have you tried the connectivity details? What does

$ psql --host 192.168.168.201 --user postgres -d raghu

give you?

I have a sneaking suspicion you don't have TCP/IP access to the database
configured in pg_hba.conf.





pgsql-general by date:

Previous
From: Neil Anderson
Date:
Subject: Re: regarding schema only migration from sqlserver to postgres with runmtk.sh
Next
From: Adrian Klaver
Date:
Subject: Re: regarding schema only migration from sqlserver to postgres with runmtk.sh