From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: regarding schema only migration from sqlserver to postgres with runmtk.sh |
Date: | 2016-06-16 15:35:34 |
Message-ID: | 351df799-b624-8bef-460c-fcb2c5237c5d@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 06/16/2016 08:13 AM, Durgamahesh Manne wrote:
> yes sir
>
> as per above discussion..i already looked pdf postgres plus guide you
> mentioned
>
> as well as i already set password for postgres user associated with
> postgres db
Is the Postgres server you are trying to connect to the Postgres
Advanced Server from EDB?
If so then you need to look here:
https://www.enterprisedb.com/docs/en/9.5/migrate/Postgres_Plus_Migration_Guide.1.15.html#
Where the important part is:
TARGET_DB_URL=jdbc:edb://192.168.168.201:5432/raghu
instead of:
TARGET_DB_URL=jdbc:postgresql://192.168.168.201:5432/raghu
>
> On Thu, Jun 16, 2016 at 8:30 PM, Durgamahesh Manne
> <maheshpostgres9(at)gmail(dot)com <mailto:maheshpostgres9(at)gmail(dot)com>> 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
> <http://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.
>
> On Thu, Jun 16, 2016 at 7:55 PM, David G. Johnston
> <david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>> wrote:
>
> On Thu, Jun 16, 2016 at 10:19 AM, Durgamahesh Manne
> <maheshpostgres9(at)gmail(dot)com <mailto:maheshpostgres9(at)gmail(dot)com>>wrote:
>
>
> sir
>
> PostgreSQL always no1 in world
> as per above discussion
>
> migration not working from sql to postgreSQL with runmtk.sh
>
>
> 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.
>
>
>
> same error repeated even there mentioned correct credentials
> as here i checked multiple times
>
>
> Maybe you should try using an IP address instead of a host name.
>
> David J.
>
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Durgamahesh Manne | 2016-06-16 15:42:01 | Re: Re: regarding schema only migration from sqlserver to postgres with runmtk.sh |
Previous Message | Durgamahesh Manne | 2016-06-16 15:30:48 | Re: regarding schema only migration from sqlserver to postgres with runmtk.sh |