Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.t.anderson@xxxxxxxxx> 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@xxxxxxxxx <mailto:maheshpostgres9@xxxxxxxxx>> 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.g.johnston@xxxxxxxxx <mailto:david.g.johnston@xxxxxxxxx>> wrote:

        On Thu, Jun 16, 2016 at 10:19 AM, Durgamahesh Manne
        <maheshpostgres9@xxxxxxxxx <mailto:maheshpostgres9@xxxxxxxxx>>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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux