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

On 2016-06-16 11:42 AM, Durgamahesh Manne wrote:
> i got another error even i specified -targetdbtype
> like
> ./runMTK.sh -sourcedbtype sqlserver -targetdbtype postgresql
> -targetSchema public -schemaOnly -allTables dbo
> Running EnterpriseDB Migration Toolkit (Build 49.0.4) ...
> Source database connectivity info...
> conn =jdbc:jtds:sqlserver://fxserver.trustfort.com:49883/DataFeedHandler
> <http://fxserver.trustfort.com:49883/DataFeedHandler>
> user =trustfort
> password=******
> Target database connectivity info...
> conn =jdbc:postgresql://192.168.168.201:5432/raghu
> <http://192.168.168.201:5432/raghu>
> user =postgres
> password=******
> Connecting with source SQL Server database server...
> Connected to Microsoft SQL Server, version '10.50.1600'
> Connecting with target Postgres database server...
> Exception in thread "main" java.lang.NoClassDefFoundError:
> org/postgresql/Driver
> at
> com.edb.dbhandler.postgresql.PGConnection.<init>(PGConnection.java:32)
> at com.edb.common.MTKFactory.createMTKConnection(MTKFactory.java:228)
> at
> com.edb.MigrationToolkit.createNewTargetConnection(MigrationToolkit.java:5987)
> at com.edb.MigrationToolkit.initToolkit(MigrationToolkit.java:3376)
> at com.edb.MigrationToolkit.main(MigrationToolkit.java:1700)
> Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver
>
>
>
>
>
> On Thu, Jun 16, 2016 at 8:59 PM, Neil Anderson
> <neil(dot)t(dot)anderson(at)gmail(dot)com <mailto:neil(dot)t(dot)anderson(at)gmail(dot)com>> wrote:
>
> On 2016-06-16 11: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
>
> On Thu, Jun 16, 2016 at 8:30 PM, Durgamahesh Manne
> <maheshpostgres9(at)gmail(dot)com <mailto:maheshpostgres9(at)gmail(dot)com>
> <mailto: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>
> <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>
> <mailto: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>
> <mailto: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.​
>
>
>
>
>
> I've never used this tool so like everyone else I am guessing here
> but having quickly looked at the documentation have you tried
> specifying the '-targetdbtype postgres' in addition to the
> '-sourcedbtype sqlserver' that you have already specified?
>
> Neil A
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>

That appears to be an issue finding the right Java library to connect to
Postgres. The documentation here outlines where to download and install
the JDBC drivers
https://www.enterprisedb.com/docs/en/9.5/migrate/Postgres_Plus_Migration_Guide.1.13.html#