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

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: Raghavendra Rao <raghavendra(dot)rao(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: regarding schema only migration from sqlserver to postgres with runmtk.sh
Date: 2016-06-15 12:31:26
Message-ID: CAJCZkoKmWKcREiTjTPy=_1EUXDzeWkKk9cRa2gVVa58K6ozsMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi sir

This is mahesh. i got following erro when i ran

./runMTK.sh -sourcedbtype sqlserver -targetSchema public -schemaOnly
-allTables dbo

below error generated as i have given correct credentials to connect
respective server & database

how to rectify this issue sir....please let me know

Running EnterpriseDB Migration Toolkit (Build 49.0.4) ...
Source database connectivity info...
conn =jdbc:jtds:sqlserver://dns name/DataFee
<http://fxserver.trustfort.com:49883/DataFeedHandler>d
user =trustfort
password=******
Target database connectivity info...
conn =jdbc:postgresql://dnsname:5432/
<http://archive.trustfort.com:5432/edb>edb
user =postgres
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.
at com.edb.MigrationToolkit.initToolkit(MigrationToolkit.java:3378)
at com.edb.MigrationToolkit.main(MigrationToolkit.java:1700)

./runMTK.sh -sourcedbtype sqlserver -targetSchema public -schemaOnly
-allTables dbo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2016-06-15 13:00:46 Re: regarding schema only migration from sqlserver to postgres with runmtk.sh
Previous Message Andreas Joseph Krogh 2016-06-15 10:56:09 Question about RUM-index