jeudi 26 mars 2015

migrating from Postgres to MonetDB [on hold]


I have postgres database (24 schemas, about 50 tables for each schema, partitioned tables) and I want to migrate to MonetDB database, but I dont know best way to do this. How can I restore data? I created same tables with DDL statement "create table myshema.mytable(...." and dump



pg_dump -t'myshema.mytable' -a mydatabase > myshema.mytable.dump


But monetdb occurs errors(first comments: syntax error, unexpected IDENT, expecting BINARY or INTO in: "-- then "syntax error, unexpected IDENT, expecting BINARY or INTO in: "") How I should do dump of data? How to restore it? Is it real to migrate from postgres to monetdb?





Aucun commentaire:

Enregistrer un commentaire