Re: Netezza and named pipes

Il 04/ott/2014 10:11 "Roger Hill" <[email protected]> ha scritto:
>
>
> My first post to the list: please be gentle!
>
> I need to copy a large volume of data every day from a Netezza database to
> several other SQL server databases.
>
> I have a solution that works: I use isql to extract to a named pipe, pass
the
> output through a couple of 'cut' steps to remove unwanted bits and
pieces, and
> then land the data on disk into a temporary file. I then use freebcp to
load
> it to the SQL server database. But it's convoluted, and I'm looking for a
> better way.
>

Well do you have any connector available? I don't  know Netezza at all.
Basically assuming there is a connector for Netezza for sql server you
setup a new connection to Netezza in sql server that you can transfer data
from Netezza to sql server using a sort of INSERT INTO TABLE SELECT ...
FROM NETEZZA TABLE.

> Two questions come out of this: Firstly  I know that freebcp did not
support
> input from named pipes as recently as 2011; is there support for named
pipes
> now?
>

Head code does. But if I understood you are converting everything to
characters and then back to database. Pay lot of attention to separators or
you risk to corrupt data!

> And secondly, something like 'datacopy' between heterogeneous databases
(in my
> case Netezza to SQL server) would eliminate a lot of mucking about on the
> intermediate box. Any chance of something like that?
>

A tool that would use just ODBC would do. I don't know any such tool.
Datacopy is written to transfer sql server to sql server only. And use
dblib which is bound to sql server.

> Any other suggestions?
>
>
> Cheers
> Roger Hill
>

Frediano