From: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
---|---|
To: | Tapan Trivedi <ttrivedi(at)webifyservices(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Migration from SQLServer |
Date: | 2003-05-16 13:14:06 |
Message-ID: | 20030516131406.51012.qmail@web20810.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--- Tapan Trivedi <ttrivedi(at)webifyservices(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Eckermann | 2003-05-16 13:17:54 | Re: Rollback when value too long |
Previous Message | Pedro C. Arias | 2003-05-16 13:10:06 | Tool for BackUp |