I have used Aqua Data Studio for just that task. (mysql and mssql to postgre). I had to do it table by table, but I did it for millions of records with relative ease. Export to delimited text file or file with insert statements, then import to the other db.
http://www.aquafold.com/ Joshua Cyr Savvy Software 866.870.6358 www.besavvy.com -----Original Message----- From: Matt Quackenbush [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 10, 2007 3:50 PM To: CF-Talk Subject: Transferring from MS SQL (2000) to PostgreSQL Hello, I have a heavily used and ever-growing MS SQL database that I would like to transfer over to PostgreSQL. It is currently 143mb (plus about 67mb in log files). The database is relatively basic, in that it does not currently use any stored procedures, and the tables makeup is pretty sql-generic. In a nutshell, I am looking for info and advice on how to best handle the transfer. Thanks in advance, Matt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266172 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4