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:266176 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
