On 6/15/2016 1:30 PM, David G. Johnston wrote:
One possible option to use the PostgreSQL's FDW capabilities with a suitable third-party extension that does talk to SQL Server.
The other is to dump plain SQL, hopefully standard-conforming, INSERT statements from the SQL Server and load them into PostgreSQL via psql.
last time I had to convert some MS SQL to another database (it was MySQL but thats immaterial), I wrote a perl script to do it. there were only 6 or 8 tables, so I manually created the schema, then my perl script stepped through each table, for each row, fetching from the source database and inserting into the destination.
--
john r pierce, recycling bits in santa cruz
