Women in Technology

Hear us Roar



Article:
  PostgreSQL for Mac OS X
Subject:   Importing from SQL Server
Date:   2002-06-10 10:37:36
From:   vineetb
Excellent article!!
Now only if there was a way to import my existing SQL 2K database into PostgresSQL....


Any ideas?

Full Threads Newest First

Showing messages 1 through 1 of 1.

  • Importing from SQL Server
    2002-06-12 04:15:29  Michael Brewer | [View]

    I haven't looked into any bulk copy procedures for this type of thing. But, off the top of my head there is a JDBC driver available from Microsoft for SQL Server 2000, so it shouldn't be much trouble to connect to your SQL Server with Java or one of the tools I used in my article to transfer your data.

    For instance, Vienna SQL will let you export the results of a query as a comma separated values file. You should then be able to use PostgreSQL's copy command to get the data in.

    A quick search on Google also returned this handy utility: http://www.daveorr.fsnet.co.uk/csvbridge/