From: | "Ryan C(dot) Bonham" <Ryan(at)srfarms(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | MS SQL 7.0 to PostgreSQL 7.1 |
Date: | 2001-05-09 15:54:12 |
Message-ID: | 19AB8F9FA07FB0409732402B4817D75A038915@FILESERVER.SRF.srfarms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am looking at PostgreSQL as an alternative to Microsoft SQL. I have a
database I would like to move to PostgreSQL to test how long it will take to
move files, how to best change our software to access Postgre, etc.. I have
PostgreSQL setup on a Test machine running Redhat 7.1. I have Postgre
successfully installed and I also have phpPgadmin installed and configured.
I have created a database, and a table, just trying to get use to Postgre.
My question is what is the best way to import my data from MS SQL. I
installed the ODBC Drivers and tried exporting using the MS import/export
tool.. It successfully creates the tables, but fails to import any data,
with a error stating that the relationship doesn't exist. So there goes the
easy route and MS POS tool.. What's the correct way of doing this?? Thanks
in advance
Ryan C. Bonham
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-05-09 16:08:22 | Re: No reference to inherited columns? |
Previous Message | Tom Lane | 2001-05-09 15:45:08 | Re: Case sensitive order by |