OT: Import/Export for PostgreSQL
All, Anyone have a suggestion for a (preferably free) Import/Export tool for PostgreSQL? I have to import/export from MS SQL Server and using MS' DTS does not seem to be working due to this bug: http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?944 Thanks, George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208185 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Import/Export for PostgreSQL
It's kind of a pain, and very slow with lots of data, but you can make sql server generate sql for the schemas (you'll have to tweak the sql a bit for it to work in postgres). You can then export the data into sql statements using the all tasksexport data function in mssql, and then run the script on postgres. Very manual, very tedious, but I've done it before and it's worked. If you're going from postgres to mssql look at pgdump (man pgdump) There is more than likely something better out there, but if it comes down to it you can do it that way. On 6/1/05, George Abraham [EMAIL PROTECTED] wrote: All, Anyone have a suggestion for a (preferably free) Import/Export tool for PostgreSQL? I have to import/export from MS SQL Server and using MS' DTS does not seem to be working due to this bug: http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?944 Thanks, George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208197 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Import/Export for PostgreSQL
George Abraham wrote: Anyone have a suggestion for a (preferably free) Import/Export tool for PostgreSQL? Export from MS SQL Server to CSV, import in PostgreSQL using COPY. Use pg_dump with full insert statements if you need to go the other way. Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208211 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54