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

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Subject: Fwd: regarding schema only migration from sqlserver to postgres with runmtk.sh
Date: 2016-06-15 15:36:07
Message-ID: CAJCZkoKLGy+0XCX5iuqYdK7v8k7i_rrv6h3Z4E+_OjMosDThAw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

---------- Forwarded message ----------
From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
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(at)postgresql(dot)org
Cc: "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>

---------- Forwarded message ----------
From: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
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 <maheshpostgres9(at)gmail(dot)com>

On Wed, Jun 15, 2016 at 11:00 AM, Durgamahesh Manne <
maheshpostgres9(at)gmail(dot)com> wrote:

> as per above discussion. i already enabled tcp/ip based access on which
> the server to listen connections from client applications as well as
> already set password for required user
>
>
> may i know the recommended approach for migrate the tables from sql server
> to postgesql
>
>
> please let me know
>
>
>
​I've helped you all that I can, and I do not respond well to personal
emails asking for help. Direct all correspondence to the list: it is ok to
CC: people who have already replied. And, as I said, this is not the
correct forum for your question. You are using a third-party tool so they
are the ones you should be asking. In this case they do monitor these
lists and may chime in but as a matter of proper etiquette this discussion
is off-topic for this list. Specifically it is a request for help on how
to use a specific non-community-PostgreSQL product.

I suspect that "dnsname" is not actually the host name for your server...if
the URL is invalid and you've munged it for email it would be impossible
for us to point out to you how/if that is so.

David J.

sir as per above discussion

conn =jdbc:postgresql://archive.tf.com:5432/
<http://archive.trustfort.com:5432/edb>edb

i earlier mentioned the host name of the server (archive.tf.com)

may i know recommended approach to migrate the tables from sql server to
postgresql instead of using 3rd party tools

thank you

&& i already enabled the listen addresses '*' to listen all available ip
interfaces

thank you

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2016-06-15 15:40:17 Re: Moving from PHP to Java: A result was returned when none was expected.
Previous Message Durgamahesh Manne 2016-06-15 15:27:44 Fwd: regarding schema only migration from sqlserver to postgres with runmtk.sh