Migrating from SQL Server to Postgres

[expired user #9480]'s profile image [expired user #9480] posted 8 years ago in General Permalink

Is it possible to migrate a SQL Server database to Postgres with HeidiSQL? I looked in the documenations, but I couldn't find an definite answer.

Thank you

ansgar's profile image ansgar posted 8 years ago Permalink

HeidiSQL's "Export database as SQL" dialog can export the whole structure of a database another server. However, that only works reliable when exporting between the same RDBMS, e.g. between MySQL and MySQL, between SQL Server + SQL Server, and between PostgreSQL + PostgreSQL. Different SQL dialects make it impossible to export from MySQL to SQL Server, or from PostgreSQL to MySQL. You can try to do that with that dialog, but the structure export will most likely fail due to some SQL error on the target server.

jfalch's profile image jfalch posted 8 years ago Permalink

look here.

Please login to leave a reply, or register at first.