Skip site navigation (1) Skip section navigation (2)

Re: Postgres and Sybase

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Rob" <rob(at)jamwarehouse(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Postgres and Sybase
Date: 2002-10-24 16:54:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

> Sorry guys, I realise that this is probably a stupid question to be
> asking,
> but I'm fast running out of options.
> I've got a  Sybase dump file and I was wondering if there is any way
> to read
> this into postgres?

What's a SyBase dump file look like?   It's been 5 years, I can't
really remember.

If it's text, we can probably bend COPY around to loading it.

It it's binary, you may be S.O.L.   TechDocs is down right now, but
look later at to see if anyone has written a
Sybase-to-PostgreSQL converter.

Also, if you have a *running* Sybase database, conversion is a lot
easier ... you can use Perl::DBI to read directly from sybase to a COPY
file, and then load the COPY file into Postgres.

-Josh Berkus

In response to

pgsql-novice by date

Next:From: Nicolas PrentzasDate: 2002-10-24 16:56:39
Subject: Parameters for views based on other views
Previous:From: Josh BerkusDate: 2002-10-24 16:49:20
Subject: Re: how to create secondary key!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group