Re: Migration from SQLServer

--- Tapan Trivedi <ttrivedi@webifyservices.com> wrote:
> Thanks Nigel but too late :-((
>
> Did try something and got really messed up. I guess
> database recreation
> is the only alternative left. Actually wanted to do
> this in 2 hrs time -
> already am late by a day.

This need not take a long time (unless you have a
really huge amount of data).  Just dump the schema
(table definitions etc.) and the data separately (man
pg_dump for details).  Check that the dump files are
ok, then drop the database.  Edit the schema dump to
force everything to lower case (easy with a small
script).  Restore the database:
psql < schema.dump
psql < data.dump
and you are fixed.

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com