Here is what I have done in the past. Use enterprise manager to script out the tables to a sql script. Then do a find an replace on the script to convert the data types and remove all of the MS specific stuff. Once you have a good generic SQL script run it on postgres to create all of your tables. Then on your MS SQL server setup an ODBC connection to the postgres server. Once you have that setup you can use Enterprise Managers export (DTS) functions to map the tables and move the data over into the postgres server. The hardest data types are id fields and dates. For Id fields set the postgres field to and integer then after the data is moved over you can flip it to and auto incrementing id. It's been a while since I have done this so I can't remember what I did about dates but maybe the odbc drivers have gotten better and will transfer better. Hope that helps. Dave
On Jan 10, 2007, at 2:49 PM, Matt Quackenbush wrote: > 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:266185 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
