regarding table migration from sql to postgres with runmtk.sh

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: pgsql-in-general(at)postgresql(dot)org
Subject: regarding table migration from sql to postgres with runmtk.sh
Date: 2016-03-09 13:11:01
Message-ID: CAJCZko+RY6BejtbX3Ci_zzSr6V5xYcUcVyfKfzO+6NY+m_JNKg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-in-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

Browse pgsql-in-general by date

  From Date Subject
Next Message Durgamahesh Manne 2016-03-11 09:04:12 Regarding connection drops for every few minutes
Previous Message John Purdie 2016-02-23 08:52:04 Re: Installation Problems