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:13:46
Message-ID: CAJCZko+nC2kU=J9a_91f-XQN_rDr6xa_zSvQSRy=oiO6SKmCYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

On Thu, Jun 16, 2016 at 8:30 PM, Durgamahesh Manne <
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
> 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 Jan de Visser 2016-06-16 15:21:51 Re: regarding schema only migration from sqlserver to postgres with runmtk.sh
Previous Message Durgamahesh Manne 2016-06-16 15:00:53 Re: regarding schema only migration from sqlserver to postgres with runmtk.sh