Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 06/15/2016 08:27 AM, Durgamahesh Manne wrote:

---------- Forwarded message ----------
From: *David G. Johnston* <david.g.johnston@xxxxxxxxx
<mailto:david.g.johnston@xxxxxxxxx>>
Date: Wed, Jun 15, 2016 at 8:40 PM
Subject: Re:  regarding schema only migration from sqlserver to
postgres with runmtk.sh
To: Durgamahesh Manne <maheshpostgres9@xxxxxxxxx
<mailto:maheshpostgres9@xxxxxxxxx>>


On Wed, Jun 15, 2016 at 11:00 AM, Durgamahesh Manne
<maheshpostgres9@xxxxxxxxx <mailto:maheshpostgres9@xxxxxxxxx>>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 <http://archive.tf.com>:5432/
<http://archive.trustfort.com:5432/edb>edb

i earlier mentioned the host name of the server (archive.tf.com
<http://archive.tf.com>)

Are you sure?

When I enter archive.tf.com or tf.com in a browser I get:

http://www.cyberfinder.com/

I would:

1) Verify the host name.

2) Then try connecting via a non-JDBC method, say using psql. If that works go to 3), otherwise come back here with information on what you did and how it failed.

3) Then try the migration tool. If that fails contact EDB.


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



thank you



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux