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