Also you should really look into updating your pg install to 8.2.9.
It takes only seconds / minutes to do. Release notes:
http://www.postgresql.org/docs/8.2/static/release-8-2-4.html
http://www.postgresql.org/docs/8.2/static/release-8-2-5.html
http://www.postgresql.org/docs/8.2/static/release-8-2
I'm using 8.2.3. I don't know which version of MySQL the faculty
member has her database in.
I really appreciate all the helpful suggestions. This seems like a
very interesting topic.
Carol
On Sep 4, 2008, at 3:42 PM, Alan Scott wrote:
What version of Postgres? We have 8.3 and have been
On Thu, 4 Sep 2008 09:24:34 -0400
Carol Walter <[EMAIL PROTECTED]> wrote:
> Hello, All,
>
> I have a new faculty member who has a large database that is in
> MySQL. We don't support MySQL so the database needs to be ported to
> PostgreSQL. Her GA, who know MySQL, says that he has a query th
What version of Postgres? We have 8.3 and have been using Migration Studio
from Enterprise DB (which is part of the Advanced Server install). Also,
with MySQL 5.0 and above they have some conversion tools that do come with
the install to assist you.
On Thu, Sep 4, 2008 at 9:24 AM, Carol Walter <[E
That's a good idea. I think I'll try that.
Carol
On Sep 4, 2008, at 1:18 PM, H. Hall wrote:
Carol Walter wrote:
Hello, All,
I have a new faculty member who has a large database that is in
MySQL. We don't support MySQL so the database needs to be ported
to PostgreSQL. Her GA, who know
Carol Walter wrote:
Hello, All,
I have a new faculty member who has a large database that is in
MySQL. We don't support MySQL so the database needs to be ported to
PostgreSQL. Her GA, who know MySQL, says that he has a query that he
will run that will put the data into postgres. I thought
According to the GA, the database has 1,000,000 rows. I hesitate to
pass that along because I don't know what that means. It strikes me
as an odd way to talk about a relational database. Normally, a
relational database has more than one table, so how is a "database"
having a million rows
On Thu, Sep 4, 2008 at 9:22 AM, Hajek, Nick <[EMAIL PROTECTED]> wrote:
>
>>
>> Hello, All,
>>
>> I have a new faculty member who has a large database that is
>> in MySQL. We don't support MySQL so the database needs to be
>> ported to PostgreSQL. Her GA, who know MySQL, says that he
>> has a quer
>
> Hello, All,
>
> I have a new faculty member who has a large database that is
> in MySQL. We don't support MySQL so the database needs to be
> ported to PostgreSQL. Her GA, who know MySQL, says that he
> has a query that he will run that will put the data into
> postgres. I thought tha
Well, my database server lives on a Solaris 10 box. I'm running
PosgreSQL 8.2.3. The database that is being converted from MySQL is
currently on a Windows machine. So far it seems that every solution
involves an interim step or two. I think he was alluding to just
running a query.
Car
I have a new faculty member who has a large database that is in
MySQL. We don't support MySQL so the database needs to be ported to
PostgreSQL. Her GA, who know MySQL, says that he has a query that he
will run that will put the data into postgres. I thought that the
data would have to be outp
Στις Thursday 04 September 2008 16:24:34 ο/η Carol Walter έγραψε:
> Hello, All,
>
> I have a new faculty member who has a large database that is in
> MySQL. We don't support MySQL so the database needs to be ported to
> PostgreSQL. Her GA, who know MySQL, says that he has a query that he
>
Στις Thursday 04 September 2008 16:24:34 ο/η Carol Walter έγραψε:
> Hello, All,
>
> I have a new faculty member who has a large database that is in
> MySQL. We don't support MySQL so the database needs to be ported to
> PostgreSQL. Her GA, who know MySQL, says that he has a query that he
>
Hello, All,
I have a new faculty member who has a large database that is in
MySQL. We don't support MySQL so the database needs to be ported to
PostgreSQL. Her GA, who know MySQL, says that he has a query that he
will run that will put the data into postgres. I thought that the
data wo
Carol Walter <[EMAIL PROTECTED]> writes:
> Can I designate a column not
> previously defined as serial to serial.
"serial" is not really a type. It's just a convenience macro for
creating a sequence and setting the column's default expression.
So what you do is perform those steps manually. Se
I'm converting a database developed by a group of students from
Oracle to Postgres. There are fields that should be primary keys
using sequences. I can get the primary keys designated but when I
try to change the type from integer to serial I get an error saying
that 'type "serial" does n
Check out the ODBC driver on the PG site. Quite simple really. Just
load the driver on your Win Box, and create the DSN.
Now all you have to do is open Access, and export your tables via ODBC.
I have only done this a few times with rather simple databases, but
haven't had any troubles.
It cre
I have had problems with the pg_dump command, though, when the tables have
been wide (many columns with long text items in them) and deep (many rows).
The pg_dump utility reloads the data from the stdin, using a pipe.
This doesn't work too well (i.e. no data gets loaded) for these tables, but
is
Steve Murphy wrote:
>
> Hi,
>
> Does anyone know of any conversion programs that will either convert an
> MS Access database file to a Postresql database or from a Filemaker Pro
> database file to a Postresql database for the Red Hat Linux OS?
>
> Any help or educated guesses of where to start
lundi 10 avril 2000 16:23
À: [EMAIL PROTECTED]
Objet: [ADMIN] Database conversion
Hi,
Does anyone know of any conversion programs that will either convert an
MS Access database file to a Postresql database or from a Filemaker Pro
database file to a Postresql database for the Red Hat Linux OS?
they i do it those infrequent times i need to is using a
program called dbf2sql that will convert from dbf.
At 02:22 PM 4/10/00 +, Steve Murphy wrote:
>Hi,
>
>Does anyone know of any conversion programs that will either convert an
>MS Access database file to a Postresql database or from a
Hi,
Does anyone know of any conversion programs that will either convert an
MS Access database file to a Postresql database or from a Filemaker Pro
database file to a Postresql database for the Red Hat Linux OS?
Any help or educated guesses of where to start looking would be
extremely welcome.
22 matches
Mail list logo
