Re: Help in Exporting PostgreSQL DB to SQL Server

From: Ramesh Rajendran <Ramesh(dot)Rajendran(at)cambridgenetwork(dot)co(dot)uk>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Help in Exporting PostgreSQL DB to SQL Server
Date: 2019-01-21 12:14:23
Message-ID: AM5PR0602MB2916D5C4EF3A916E0029D851A39F0@AM5PR0602MB2916.eurprd06.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi

I am trying to Export PostgreSQL into SQL Server

But For some reason I do have an issue and I couldn't find a right way also Online help is not helping me much

Can you please let me know how can this be made easier ?

Also reason for me to export PostgreSQL to SQL server:

All our data are right now stored in PostgreSQL and we are migrating to Mysql server (PHP).

So we have to give a CSV file of our current data dump to the new provider to import in Mysql

When I export from PostgreSQL any special char in the database is exported as some special char and this is causing us problem

So is there a way I can export all the data as it is in database to notepad?

Please let me know the status

Thanks
Ramesh Rajendran

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website.

Browse pgsql-odbc by date

  From Date Subject
Next Message Pierre Couderc 2019-01-28 22:57:45 Erreur when testing connection
Previous Message Neumann, Gregor 2019-01-15 15:33:09 Character with byte sequence has no equivalent in encoding.