Re: regarding table migration from sql to postgres with runmtk.sh

On Wed, Mar 9, 2016 at 7:26 AM, Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com
> wrote:

> 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)
>
>
​Looks like the driver issue.
./runMTK.sh​ is EnterpriseDB Migration Studio tool. Can you please reach
out to EnterpriseDB support or Forum.

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/