RE: LONG: How to migrate data from MS-SQL7 to PostgreSQ L 7.0

Started by Peter Mountover 25 years ago2 messages
#1Peter Mount
petermount@it.maidstone.gov.uk

Yes, as that's why I posted it ;-)

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

-----Original Message-----
From: Thomas Lockhart [mailto:lockhart@alumni.caltech.edu]
Sent: Thursday, May 18, 2000 4:21 PM
To: Peter Mount
Cc: PostgreSQL Developers List (E-mail); PostgreSQL Interfaces (E-mail)
Subject: Re: [HACKERS] LONG: How to migrate data from MS-SQL7 to
PostgreSQL 7.0

This is how to get MS-SQL7 to copy data (either whole tables, or from
queries) into PostgreSQL...

Nice writeup. Can I fold it into our docs chapter on populating
databases (or some other appropriate place)?

- Thomas

--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California

#2Peter Mount
petermount@it.maidstone.gov.uk
In reply to: Peter Mount (#1)

It's on my ever growing list of things to do, to do the same for
StarOffice, getting it to work with PostgreSQL (using JDBC).

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

-----Original Message-----
From: Cary O'Brien [mailto:cobrien@Radix.Net]
Sent: Friday, May 19, 2000 12:19 AM
To: pgsql-hackers@hub.org
Subject: Re: [HACKERS] LONG: How to migrate data from MS-SQL7 to
PostgreSQL 7.0

This is how to get MS-SQL7 to copy data (either whole tables, or

from

queries) into PostgreSQL...

Nice writeup. Can I fold it into our docs chapter on populating
databases (or some other appropriate place)?

I like how the Zope site has "howtos" and "tips"[1]http://www.zope.org/Documentation. I think this might
be better because of the dynamic nature of this information. I'd be
glad
to contribute what I have about getting Applixware to talk to
PostgreSQL[2]http://www.radix.net/~cobrien/applix/applix.txt,
But I need to check things out with the Applixware 5.0 and PostgreSQL
7.0.

You could even use Zope itself to do this stuff.

-- cary

[1]: http://www.zope.org/Documentation
[2]: http://www.radix.net/~cobrien/applix/applix.txt