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

2016-06-16 Thread Durgamahesh Manne
i already set password ..it appears when executing the runmtk.sh jdbc already mentioned On Thu, Jun 16, 2016 at 9:12 PM, Jan de Visser wrote: > > P L E A S E D O N ' T T O P P O S T > > > > On Thursday, June 1

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

2016-06-16 Thread Jan de Visser
P L E A S E D O N ' T T O P P O S T On Thursday, June 16, 2016 9:00:48 PM EDT Durgamahesh Manne wrote: > as per above conversation. i checked connectivity details as it is > connected to database (even hostnam

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

2016-06-16 Thread Adrian Klaver
On 06/16/2016 08: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 Is the Postgres server you are trying to connect to the Postgres Advanced S

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

2016-06-16 Thread Durgamahesh Manne
as per above conversation. i checked connectivity details as it is connected to database (even hostname i mentioned connected to database) psql --host 192.168.168.201 --user postgres -d raghu Password for user postgres: psql.bin (9.4.8, server 9.4.4) Type "help" for help. No entry for terminal

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

2016-06-16 Thread Jan de Visser
Please don't top-post. On Thursday, June 16, 2016 8:30:53 PM EDT Durgamahesh Manne 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_UR

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

2016-06-16 Thread Durgamahesh Manne
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 < maheshpostgr...@gmail.com> wrote: > hi > sir > as per above discussion sam

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

2016-06-16 Thread Durgamahesh Manne
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 TARGET_DB_USER=postgres TARGET_DB_PASSWORD=* Connecting w

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

2016-06-16 Thread Adrian Klaver
On 06/16/2016 07:19 AM, Durgamahesh Manne 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 wit

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

2016-06-16 Thread Durgamahesh Manne
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:

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

2016-06-16 Thread David G. Johnston
On Thu, Jun 16, 2016 at 10:19 AM, Durgamahesh Manne < maheshpostgr...@gmail.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 Mi

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

2016-06-16 Thread Adrian Klaver
On 06/15/2016 08:50 PM, Durgamahesh Manne wrote: sir as per above discussion .the URL which i mentioned in toolkit properties was 100% correct .i have checked db connectivity from another cluster with psql .connection esatblished to below mentioned database conn =jdbc:postgresql://archive.trustf

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

2016-06-15 Thread Durgamahesh Manne
eneral@postgresql.org > *Subject:* Re: [GENERAL] regarding schema only migration from sqlserver > to postgres with runmtk.sh > > > > On Wed, Jun 15, 2016 at 11:27 AM, Durgamahesh Manne < > maheshpostgr...@gmail.com> wrote: > > may i know recommended approach to migr

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

2016-06-15 Thread Mike Sofen
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G. Johnston Sent: Wednesday, June 15, 2016 1:31 PM To: Durgamahesh Manne Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] regarding schema only migration from sqlserver to postgres

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

2016-06-15 Thread John R Pierce
On 6/15/2016 1:30 PM, David G. Johnston wrote: One possible option to use the PostgreSQL's FDW capabilities with a suitable third-party extension that does talk to SQL Server. The other is to dump plain SQL, hopefully standard-conforming, INSERT statements from the SQL Server and load them int

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

2016-06-15 Thread Joshua D. Drake
On 06/15/2016 01:30 PM, David G. Johnston wrote: On Wed, Jun 15, 2016 at 11:27 AM, Durgamahesh Manne mailto:maheshpostgr...@gmail.com>>wrote: may i know recommended approach to migrate the tables from sql server to postgresql instead of using 3rd party tools ​Answering this specifical

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

2016-06-15 Thread David G. Johnston
On Wed, Jun 15, 2016 at 11:27 AM, Durgamahesh Manne < maheshpostgr...@gmail.com> wrote: > > i earlier mentioned the host name of the server (archive.tf.com) > > ​No, you did not. And if you believe you did that may indeed be part of the problem. The log you showed has this: conn =jdbc:postgresq

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

2016-06-15 Thread David G. Johnston
On Wed, Jun 15, 2016 at 11:27 AM, Durgamahesh Manne < maheshpostgr...@gmail.com> wrote: > may i know recommended approach to migrate the tables from sql server to > postgresql instead of using 3rd party tools > > ​Answering this specifically. There are none. The community PostgreSQL project mai

Re: Fwd: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

2016-06-15 Thread Adrian Klaver
On 06/15/2016 08:27 AM, Durgamahesh Manne wrote: -- Forwarded message -- From: *David G. Johnston* mailto:david.g.johns...@gmail.com>> Date: Wed, Jun 15, 2016 at 8:40 PM Subject: Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk

Fwd: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

2016-06-15 Thread Durgamahesh Manne
-- Forwarded message -- From: Durgamahesh Manne Date: Wed, Jun 15, 2016 at 8:57 PM Subject: Fwd: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh To: pgsql-general@postgresql.org Cc: "David G. Johnston" -- Forward

Fwd: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

2016-06-15 Thread Durgamahesh Manne
-- Forwarded message -- From: David G. Johnston Date: Wed, Jun 15, 2016 at 8:40 PM Subject: Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh To: Durgamahesh Manne On Wed, Jun 15, 2016 at 11:00 AM, Durgamahesh Manne < maheshpos

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

2016-06-15 Thread David G. Johnston
On Wed, Jun 15, 2016 at 8:31 AM, Durgamahesh Manne < maheshpostgr...@gmail.com> wrote: > Running EnterpriseDB Migration Toolkit (Build 49.0.4) ... > ​You should contact the supplier of this tool using their support channels. The community is not responsible for this product. I will note that by

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

2016-06-15 Thread Durgamahesh Manne
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 sirplease let me know Ru