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
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 |