From: | Jan de Visser <jan(at)de-visser(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Subject: | Re: regarding schema only migration from sqlserver to postgres with runmtk.sh |
Date: | 2016-06-16 15:21:51 |
Message-ID: | 2102949.es4NXt4yyn@coyote |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Anderson | 2016-06-16 15:29:08 | Re: regarding schema only migration from sqlserver to postgres with runmtk.sh |
Previous Message | Durgamahesh Manne | 2016-06-16 15:13:46 | Re: regarding schema only migration from sqlserver to postgres with runmtk.sh |