Re: linking from SQL Server

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "SHELTON,MICHAEL (Non-HP-Boise,ex1)" <michael_shelton(at)non(dot)hp(dot)com>, "'Josh Berkus'" <josh(at)agliodbs(dot)com>, Oleg Lebedev <olebedev(at)waterford(dot)org>, Postgres SQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: linking from SQL Server
Date: 2002-01-25 16:16:34
Message-ID: web-675884@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Mike,

> I have access to a SQL 2000 server if you can give me some detailed
> instructions I'd be happy to test it out for you. I'm also
> interested in
> seeing if this will work.

1. Get the PostgresODBC server from PgAdmin
(http://pgadmin.postgresql.org/)
2. Install it and set up an ODBC source pointing to a PostgreSQL server
(you have one, yes?)
3. Use Data Transformation Service to:
a) Import data from the Postgres Server into SQL Server
b) Export data from SQL Server to PostgreSQL.
4. Tell us what works.

Anything else, Oleg?

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Arve Fahlvik 2002-01-25 16:29:53 Complex column ref.
Previous Message alexandre paes :: aldeia digital 2002-01-25 15:59:11 LIMIT Optimization