It might be useful to use one of the database abstraction tools that can look at either mssql or postgres. Reactor is one http://www.doughughes.net/includes/reactor/*reactor.zip* Datamgr is another http://www.bryantwebconsulting.com/cfcs/ These have already done the work of figuring out the differences so I would imagine that you could use these to read from one datasource and write to the other with the majority of translation work done for you.
Datamgr has a createTable method, (not sure about reactor) which should help you out. On 7/18/06, Gonzo Rock <[EMAIL PROTECTED]> wrote: > > Hello, > > I have been directed to move a database off postgreSQL to MS and was > looking to this list for any advise before I begin. I have been reviewing > the online resources and have a few ideas in mind. > > Looking into things like SELECT INTO and pgdump -D for the insert > statements... I will have to convert boolean into char etc. > > This list has always been the best resource when I need to learn something > new so I wanted to pass it by you all too. > > Thank you for your effort, > Gonzo > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247033 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
