On 1/11/25 03:05, Andy Hartman wrote:
I used PS to pull the data from mssql to Postgres dumping data to csv.
I then used csv to load Postgres and the table that has Bytea
What data type was used to store data in MySQL?
Show command used to pull data from MySQL.
# Convert the image data to a base64 string -- powershell
$base64Image = [Convert]::ToBase64String($row.ImageSource)
AFter data was loaded the developer said in his app frontend that the
Image wouldn't open thru his code. -- I'm trying to get that code to
help debug
He said the size of the array is 1368. from bytea The size coming from
How does an array enter into this?
the SQL-Server db is 46935 and the image correctly appears...
Could that be caused by my PS dump to csv process or maybe still a
code(frontend) issue..
Still trying to figure out using a single record if data loaded to the
bytea field matches the mssql record.
I tried to use the tool SimplySql to connect mssql to postgresql to
transfer data but it failed ...
any help would be appreciated..
On Fri, Jan 10, 2025 at 12:35 PM Erik Wienhold <ewie@xxxxxxxxx
<mailto:ewie@xxxxxxxxx>> wrote:
On 2025-01-09 21:31 +0100, Andy Hartman wrote:
> could it be done using Powershell?
I use this: https://blog.cleverelephant.ca/2021/04/psql-binary.html
<https://blog.cleverelephant.ca/2021/04/psql-binary.html>
But I don't know if that translates to PowerShell.
--
Erik Wienhold
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
