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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: regarding schema only migration from sqlserver to postgres with runmtk.sh
Дата
Msg-id CAKFQuwZRq+J3-O9wfb+cc1LP7=zqP=yJ0rPcgWQnH8tnva6VOw@mail.gmail.com
обсуждение исходный текст
Ответ на Fwd: regarding schema only migration from sqlserver to postgres with runmtk.sh  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
Ответы Re: regarding schema only migration from sqlserver to postgres with runmtk.sh  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: regarding schema only migration from sqlserver to postgres with runmtk.sh  (John R Pierce <pierce@hogranch.com>)
Re: regarding schema only migration from sqlserver to postgres with runmtk.sh  ("Mike Sofen" <msofen@runbox.com>)
Список pgsql-general
On Wed, Jun 15, 2016 at 11:27 AM, Durgamahesh Manne <maheshpostgres9@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 maintains no tools that speak to SQL Server.

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 into PostgreSQL via psql.

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.


Depending on the table structures having SQL Server dump the DDL (i.e., CREATE TABLE) for the tables and loading them via psql might be possible as well.

​One area that the commercial space ​helps fulfill is inter-vendor inter-operability tools.  While this is a boon to the PostgreSQL community as matter of practicality support for those tools.  Before using said tools you should ensure that you can reliably connect, using the standard tools, to the databases in question and perform general actions thereon.  Failures there should be resolved first and the communities can help you with that.

David J.



В списке pgsql-general по дате отправления:

Предыдущее
От: Jan de Visser
Дата:
Сообщение: Re: Moving from PHP to Java: A result was returned when none was expected.
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: regarding schema only migration from sqlserver to postgres with runmtk.sh