[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.kla...@aklaver.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.kla...@aklaver.com > >
