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.trustfort.com:5432/edb
thank you for the valuable information On Thu, Jun 16, 2016 at 3:08 AM, Mike Sofen <mso...@runbox.com> wrote: > > > *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 <maheshpostgr...@gmail.com> > *Cc:* pgsql-general@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 migrate the tables from sql server to > postgresql instead of using 3rd party tools > > > > > > I suppose SQL Server has some means to export in TSV/CSV or other > row-oriented structured output. The \copy psql meta-command or COPY SQL > command could load that data. > > > > David J. > > > > > > There are MANY tools for sql server, many are built in (aka free) that > will generate DDL, or extract data, or both, plus you can directly query > the system catalogs, just like PG. Utterly trivial stuff to use and > Postgres can ingest all of it since it’s normally either flat file or ansi > sql. > > > > MikeS >
