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

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
user =trustfort
password=******
Target database connectivity info...
conn =jdbc:postgresql://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>
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>> 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>
>> 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>>
>> wrote:
>>
>> On Thu, Jun 16, 2016 at 10:19 AM, Durgamahesh Manne
>> <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)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>