Example Code

Jul 8, 2015 at 3:54 PM
I am in the process of writing a c# app moves data from a sql server to a postgresql server. I have everything working but the process of streaming the data from one server to the other is really slow on the big tables. What I would like to do is to compress the data being taken from the sql server, compress it, send it over the network to the postgresql server, uncompress it and find the uncompressed day to postgresql's copy command.

I was hoping someone could provide me examples of using the code in a c# environment to compress the data using the zlib wrapper library. Just some general usage examples and I can work the rest out.

Thanks in advance for you help