Re: Table copy

[6992] ERROR: unexpected EOF on client connection with an open transaction
2025-02-05 12:19:44.919 EST [6992] CONTEXT: COPY sqlt_data_1_2022_03, line
24431524, column dataintegrity
2025-02-05 12:19:44.919 EST [6992] STATEMENT: COPY sqlt_data_1_2022_03
(tagid, intvalue, floatvalue, stringvalue, datevalue, dataintegrity,
t_stamp) FROM STDIN (FORMAT BINARY)
2025-02-05 12:19:44.919 EST [6992] FATAL: terminating connection because
protocol synchronization was lost

On Wed, Feb 5, 2025 at 11:15 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 2/5/25 05:40, Andy Hartman wrote:
> > mssql - 2016
> > PG - 16.1
> > latest release for Simplysql
> Latest is a relative term and requires anyone in the future coming
> across this thread to work out what you are talking about. For that
> person the current version is 2.1.0.
>
> > Invoke-SqlBulkCopy -SourceConnectionName "src" -SourceTable
> > "sqlt_data_1_2022_03" -DestinationConnectionName "dst" -DestinationTable
> > "sqlt_data_1_2022_03" -BatchSize 10000 -Notify
> >
> > 2.4 billion records -- I have down other tables of same size no problems
>
> Same version of SimplySql?
>
> Same source and destination databases?
>
> Did you look at the Postgres and system logs to see if there was
> relevant information?
>
>
> >
> > mssql OS Windows Server 2019
> > PG OS Windows Server 2022
> >
> > Table:
> > image.png
> >
> >
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>