Re: linking from SQL Server

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
Serverto PostgreSQL.
 
4. Tell us what works.

Anything else, Oleg?

-Josh


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