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.
>>
>>
>
>
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 |