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

as per above conversation. i checked connectivity details as it is
connected to database (even hostname i mentioned connected to database)
psql --host 192.168.168.201 --user postgres -d raghu
Password for user postgres:
psql.bin (9.4.8, server 9.4.4)
Type "help" for help.

No entry for terminal type "xterm";
using dumb terminal settings.
raghu=#

On Thu, Jun 16, 2016 at 8:51 PM, Jan de Visser <jan(at)de-visser(dot)net> wrote:

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