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
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
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.
Please login to leave a reply, or register at first.