Wasn't Aqua Data Studio free at one point? I swear I didn't buy it... but could be forgetting. I don't do the warez thing, so either it was legitimately free at one point or very inexpensive or I am losing too many brain cells on WOW.
-----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 10, 2007 4:17 PM To: CF-Talk Subject: Re: Transferring from MS SQL (2000) to PostgreSQL Joshua Cyr wrote: > 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/ > I'll +1 Aqua Data Studio...but I don't think you will need to do it table by table...if you right click on the database, and go to Tools/Script Generator, it will bring up a wizard that will create a single file with CREATE statements for all of your tables, views, indexes, etc. and INSERT statements for all of your data (basically a file like mysqldump or pg_dump creates). It allows you some customization in the export, such as what the statement separator is and what to wrap object names in ([] vs ``)...I haven't used it going from MS-SQL ---> PostgreSQL, but I have gone MS-SQL ---> MySQL and the created file needed little modification. Unfortunately they just raised the price.... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:266177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
