postgre to mysql

[Ja]{|e]

ho un grosso database fatto con postgre, ma dovrei convertilo in mysql (tra l'altro modificando i nomi di alcune tabelle, le applicazione che hanno scritto per questo database sono tutte case sensitive e quindi devo mettere tutto in minuscolo), come posso fare?

[filippo.toso]

Puoi provare facendo il dump in SQL della struttura e dei dati (in due file separati).
Poi provi ad importare l'SQL della struttura, sistemando le eventuali differenze tra l'SQL dei due database.
Infine provi ad importare l'SQL dei dati.

[Ja]{|e]

ho provato già a fare il dump con navicat (ho fatto una prova con un db con due sole tabelle) e mi ha dato questo

/*
PGSQL Data Transfer
Source Host: localhost
Source Database: prova
Target Host: localhost
Target Database: prova
Date: 12/10/2008 16.54.26
*/


-- ----------------------------
-- Table structure for "public"."prova1"
-- ----------------------------
drop table "public"."prova1";
CREATE TABLE "public"."prova1"(
"col1" char(1) NOT NULL ,
"col2" char(1) ,
PRIMARY KEY ("col1")
)  WITHOUT OIDS;

-- ----------------------------
-- Table structure for "public"."prova2"
-- ----------------------------
drop table "public"."prova2";
CREATE TABLE "public"."prova2"(
"col3" char(1) ,
"col4" char(1) 
)  WITHOUT OIDS;

-- ----------------------------
-- Function structure for "pg_catalog"."pg_file_length"(text)
-- ----------------------------
DROP FUNCTION "pg_catalog"."pg_file_length"(text);
CREATE FUNCTION "pg_catalog"."pg_file_length"(text)
  RETURNS int8 AS 
$BODY$SELECT size FROM pg_catalog.pg_stat_file($1)$BODY$  LANGUAGE 'sql' VOLATILE;
ALTER FUNCTION "pg_catalog"."pg_file_length"(text) OWNER TO postgres;
COMMENT ON FUNCTION "pg_catalog"."pg_file_length"(text) IS '';
;

-- ----------------------------
-- Function structure for "pg_catalog"."pg_file_read"(text, int8, int8)
-- ----------------------------
DROP FUNCTION "pg_catalog"."pg_file_read"(text, int8, int8);
CREATE FUNCTION "pg_catalog"."pg_file_read"(text, int8, int8)
  RETURNS text AS 
$BODY$pg_read_file$BODY$  LANGUAGE 'internal' VOLATILE;
ALTER FUNCTION "pg_catalog"."pg_file_read"(text, int8, int8) OWNER TO postgres;
COMMENT ON FUNCTION "pg_catalog"."pg_file_read"(text, int8, int8) IS '';
;

-- ----------------------------
-- Function structure for "pg_catalog"."pg_file_rename"(text, text, text)
-- ----------------------------
DROP FUNCTION "pg_catalog"."pg_file_rename"(text, text, text);
CREATE FUNCTION "pg_catalog"."pg_file_rename"(text, text, text)
  RETURNS bool AS '$libdir/adminpack', 'pg_file_rename'
  LANGUAGE 'c' VOLATILE;
ALTER FUNCTION "pg_catalog"."pg_file_rename"(text, text, text) OWNER TO postgres;
COMMENT ON FUNCTION "pg_catalog"."pg_file_rename"(text, text, text) IS '';
;

-- ----------------------------
-- Function structure for "pg_catalog"."pg_file_rename"(text, text)
-- ----------------------------
DROP FUNCTION "pg_catalog"."pg_file_rename"(text, text);
CREATE FUNCTION "pg_catalog"."pg_file_rename"(text, text)
  RETURNS bool AS 
$BODY$SELECT pg_catalog.pg_file_rename($1, $2, NULL::pg_catalog.text);$BODY$  LANGUAGE 'sql' VOLATILE;
ALTER FUNCTION "pg_catalog"."pg_file_rename"(text, text) OWNER TO postgres;
COMMENT ON FUNCTION "pg_catalog"."pg_file_rename"(text, text) IS '';
;

-- ----------------------------
-- Function structure for "pg_catalog"."pg_file_unlink"(text)
-- ----------------------------
DROP FUNCTION "pg_catalog"."pg_file_unlink"(text);
CREATE FUNCTION "pg_catalog"."pg_file_unlink"(text)
  RETURNS bool AS '$libdir/adminpack', 'pg_file_unlink'
  LANGUAGE 'c' VOLATILE;
ALTER FUNCTION "pg_catalog"."pg_file_unlink"(text) OWNER TO postgres;
COMMENT ON FUNCTION "pg_catalog"."pg_file_unlink"(text) IS '';
;

-- ----------------------------
-- Function structure for "pg_catalog"."pg_file_write"(text, text, bool)
-- ----------------------------
DROP FUNCTION "pg_catalog"."pg_file_write"(text, text, bool);
CREATE FUNCTION "pg_catalog"."pg_file_write"(text, text, bool)
  RETURNS int8 AS '$libdir/adminpack', 'pg_file_write'
  LANGUAGE 'c' VOLATILE;
ALTER FUNCTION "pg_catalog"."pg_file_write"(text, text, bool) OWNER TO postgres;
COMMENT ON FUNCTION "pg_catalog"."pg_file_write"(text, text, bool) IS '';
;

-- ----------------------------
-- Function structure for "pg_catalog"."pg_logdir_ls"()
-- ----------------------------
DROP FUNCTION "pg_catalog"."pg_logdir_ls"();
CREATE FUNCTION "pg_catalog"."pg_logdir_ls"()
  RETURNS record AS '$libdir/adminpack', 'pg_logdir_ls'
  LANGUAGE 'c' VOLATILE;
ALTER FUNCTION "pg_catalog"."pg_logdir_ls"() OWNER TO postgres;
COMMENT ON FUNCTION "pg_catalog"."pg_logdir_ls"() IS '';
;

-- ----------------------------
-- Function structure for "pg_catalog"."pg_logfile_rotate"()
-- ----------------------------
DROP FUNCTION "pg_catalog"."pg_logfile_rotate"();
CREATE FUNCTION "pg_catalog"."pg_logfile_rotate"()
  RETURNS int4 AS 
$BODY$pg_rotate_logfile$BODY$  LANGUAGE 'internal' VOLATILE;
ALTER FUNCTION "pg_catalog"."pg_logfile_rotate"() OWNER TO postgres;
COMMENT ON FUNCTION "pg_catalog"."pg_logfile_rotate"() IS '';
;

-- ----------------------------
-- Function structure for "pg_catalog"."plpgsql_call_handler"()
-- ----------------------------
DROP FUNCTION "pg_catalog"."plpgsql_call_handler"();
CREATE FUNCTION "pg_catalog"."plpgsql_call_handler"()
  RETURNS language_handler AS '$libdir/plpgsql', 'plpgsql_call_handler'
  LANGUAGE 'c' VOLATILE;
ALTER FUNCTION "pg_catalog"."plpgsql_call_handler"() OWNER TO postgres;
COMMENT ON FUNCTION "pg_catalog"."plpgsql_call_handler"() IS '';
;

-- ----------------------------
-- Function structure for "pg_catalog"."plpgsql_validator"(oid)
-- ----------------------------
DROP FUNCTION "pg_catalog"."plpgsql_validator"(oid);
CREATE FUNCTION "pg_catalog"."plpgsql_validator"(oid)
  RETURNS void AS '$libdir/plpgsql', 'plpgsql_validator'
  LANGUAGE 'c' VOLATILE;
ALTER FUNCTION "pg_catalog"."plpgsql_validator"(oid) OWNER TO postgres;
COMMENT ON FUNCTION "pg_catalog"."plpgsql_validator"(oid) IS '';
;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO "public"."prova1" VALUES ('w', 'e');
INSERT INTO "public"."prova2" VALUES ('q', 'a');

ho provato a darlo in pasto a easyphp ma mi restituisce continuamente codici di errore del tipo tabella1 non riconosciuta

[Ja]{|e]

up