All,
Anyone have a suggestion for a (preferably free) Import/Export tool
for PostgreSQL? I have to import/export from MS SQL Server and using
MS' DTS does not seem to be working due to this bug:
http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?944
Thanks,
George
It's kind of a pain, and very slow with lots of data, but you can make
sql server generate sql for the schemas (you'll have to tweak the
sql a bit for it to work in postgres). You can then export the data
into sql statements using the all tasksexport data function in mssql,
and then run the script
George Abraham wrote:
Anyone have a suggestion for a (preferably free) Import/Export tool
for PostgreSQL?
Export from MS SQL Server to CSV, import in PostgreSQL using
COPY. Use pg_dump with full insert statements if you need to go
the other way.
Jochem
3 matches
Mail list logo