Re: Importing directly from BCP files

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Importing directly from BCP files
Дата
Msg-id 564A7A41.1050100@aklaver.com
обсуждение исходный текст
Ответ на Re: Importing directly from BCP files  (Tim Uckun <timuckun@gmail.com>)
Ответы Re: Importing directly from BCP files  (Tim Uckun <timuckun@gmail.com>)
Список pgsql-general
On 11/16/2015 04:25 PM, Tim Uckun wrote:
>     the binary form of the BCP file output is undocumented. So if all
>     the BCP files you have are the binary(native) version you are up
>     this creek without a paddle.
>
>
> Ugh.  Yes it looks like that's the creek I am on.   Thanks Microsoft!
>
>     So, moving to another creek. It depends on the amount of data you
>     are working with, but it might be worth it to spin up a VM in the
>     cloud on AWS, Azure, etc that has SQL Server on it and import the
>     BCP files there. You could then export the data using the character
>     format instead of the native format:
>
>
> Man that really sucks but if it's the only way then I guess it's the
> only way.

Something else that came to mind, where did you get the BCP files from
and is possible the source could create the text based versions instead
of the binary?

--
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Adding a new module to postgres
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: bdr appears to be trying to replicate to itself