Women in Technology

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?

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/