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

Поиск
Список
Период
Сортировка
От Mike Sofen
Тема Re: regarding schema only migration from sqlserver to postgres with runmtk.sh
Дата
Msg-id 034c01d1c74e$46a2b5a0$d3e820e0$@runbox.com
обсуждение исходный текст
Ответ на Re: regarding schema only migration from sqlserver to postgres with runmtk.sh  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: regarding schema only migration from sqlserver to postgres with runmtk.sh  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
Список pgsql-general
Дерево обсуждения

 

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

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: regarding schema only migration from sqlserver to postgres with runmtk.sh
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Question about RUM-index