| 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: | Whole Thread | Raw Message | 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 |