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