Re: regarding schema only migration from sqlserver to postgres with runmtk.sh

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: "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:00:53
Message-ID: CAJCZkoJ=aUZorU4PaxxQ5QW3fcBcVC6zNwvziJtpDCGrLs2HYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

On Thu, Jun 16, 2016 at 7:55 PM, David G. Johnston <
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> 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.​
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Durgamahesh Manne 2016-06-16 15:13:46 Re: regarding schema only migration from sqlserver to postgres with runmtk.sh
Previous Message Adrian Klaver 2016-06-16 14:33:15 Re: regarding schema only migration from sqlserver to postgres with runmtk.sh