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

From Jan de Visser
Subject Re: regarding schema only migration from sqlserver to postgres with runmtk.sh
Date
Msg-id 2102949.es4NXt4yyn@coyote
Whole thread Raw
In response to Re: regarding schema only migration from sqlserver to postgres with runmtk.sh  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
Responses Re: regarding schema only migration from sqlserver to postgres with runmtk.sh
List pgsql-general
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: Durgamahesh Manne
Date:
Subject: Re: regarding schema only migration from sqlserver to postgres with runmtk.sh
Next
From: Neil Anderson
Date:
Subject: Re: regarding schema only migration from sqlserver to postgres with runmtk.sh