Tomi NA wrote:
> I'd like to transfer table structure and _data_ from a source mssql
> database
> to a postgresql database.
> Has anyone here tried something like this? I have a feeling parts of
> cayenne
> code might be of help, but it's hard to think clearly after straight 16
> hours of staring at the screen...any suggestions would be very welcome.
>
Hello,
have you considered just dumping the structure and data, and inserting it
into postgres, outside of cayenne?
# mysqldump -u username -p password database_name > file.sql
edit out you mysql badness
# psql -d myDataBase (-a) -f file.sql
hth,
Matt
This archive was generated by hypermail 2.0.0 : Wed Feb 15 2006 - 21:40:54 EST