regarding table migration from sql to postgres with runmtk.sh

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: regarding table migration from sql to postgres with runmtk.sh
Date: 2016-03-09 13:26:38
Message-ID: CAJCZkoKKrYVOBrgTtbv2-t9A5-c=8Pq=J=78YOseiQ2C5v+vZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi sir
i got following erro when i ran runmtk.sh

initially i placed the jtds driver related to sql in
/opt/postgresplus/edbmtk/lib

./runMTK.sh -sourcedbtype sqlserver -targetdbtype postgresql
feeds_morningstar_bond_sector
Running EnterpriseDB Migration Toolkit (Build 48.0.2) ...
Source database connectivity info...
conn =jdbc:jtds:sqlserver://fxserver.trustfort.com:49888/DataFeedHandler
user =trustfort
password=******
Target database connectivity info...
conn =jdbc:postgresql://192.168.24.128:5432/dbo_sql
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:5610)
at com.edb.MigrationToolkit.initToolkit(MigrationToolkit.java:3122)
at com.edb.MigrationToolkit.main(MigrationToolkit.java:1521)
Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:358)

regards
mahesh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2016-03-09 13:37:50 Re: regarding table migration from sql to postgres with runmtk.sh
Previous Message David Bennett 2016-03-09 13:16:19 Email address VERP problems (was RE: Does a call to a language handler provide a context/session, and somewhere to keep session data?