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
# 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 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 <e...@ewie.name> 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
> But I don't know if that translates to PowerShell.
>
> --
> Erik Wienhold
>
