regarding table migration from sql to postgres with runmtk.sh - Mailing list pgsql-general

From Durgamahesh Manne
Subject regarding table migration from sql to postgres with runmtk.sh
Date
Msg-id CAJCZkoKKrYVOBrgTtbv2-t9A5-c=8Pq=J=78YOseiQ2C5v+vZA@mail.gmail.com
Whole thread Raw
Responses Re: regarding table migration from sql to postgres with runmtk.sh  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: regarding table migration from sql to postgres with runmtk.sh  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List 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...
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

pgsql-general by date:

Previous
From:
Date:
Subject: Re: Re: "missing chunk number XX for toast value YY in pg_toast ..." after pg_basebackup.
Next
From: Andrew Sullivan
Date:
Subject: Re: regarding table migration from sql to postgres with runmtk.sh