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

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 <msofen(at)runbox(dot)com> wrote:

>
>
> *From:* pgsql-general-owner(at)postgresql(dot)org [mailto:
> pgsql-general-owner(at)postgresql(dot)org] *On Behalf Of *David G. Johnston
> *Sent:* Wednesday, June 15, 2016 1:31 PM
> *To:* Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
> *Cc:* pgsql-general(at)postgresql(dot)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 <
> maheshpostgres9(at)gmail(dot)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
>