Database Migration

Поиск
Список
Период
Сортировка
От
Тема Database Migration
Дата
Msg-id 20050909234934.92835.qmail@web33301.mail.mud.yahoo.com
обсуждение исходный текст
Список pgsql-novice
Hi All,

i'm facing a db / data migration issue.  i have 3 dbs.

my dev box is pgsql 7.4.6 (laptop, winxp / cygwin)
my current production box is 7.3.x (webhost, linux)
my new production box is 8.03 (in-house, linux)

my dev db is waaaay ahead of my production db b/c i
had to code a lot of pages to include some
functionality.

i'm thinking about doing this two ways.

1. dump my table structures from my dev box and then
fill it with data from the 7.3.x production db and
hope there are are no glitches.
2. build the pgsql 8.03 from scratch and then fill it
with data from the 7.3.x production db and hope there
are are no glitches.

do these options sound reasonable?  will 7.4.6 data
types conflict with 8.03 data types?

tia...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

В списке pgsql-novice по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: Weird SQL Problem
Следующее
От: "Peter Schonefeld"
Дата:
Сообщение: inserting non-ascii characters