I am trying to migrate a database from Oracle to Postgresql. I am using the
PgAdmin database migration wizard (1.5.60-Dev) to do this. Using ODBC I am
able to migrate small tables but I have a few tables that have over 10
million rows that are failing. I know the reason as I am getting an
"Snapshot
Hi,
Every time I have to specify a table name in a query I find myself prefixing
the name of the table with the schema name as in schema.table. Is there a
way to force the queries to look in one particular schema whenever I do not
specify a schema name?
thanks
dilan
---(e
Just wondering if anyone has tried to use the MS Data Transformation
Services (DTS) to migrate data from other databases (Oracle etc) via ODBC. I
am considering looking into this as it looks promising due to the flexible
options it offers over the database migration wizard in PgAdmin.
thanks
dilan
