Re: postgreSQL to MS-SQL

2006-07-19 Thread Michael Traher
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

postgreSQL to MS-SQL

2006-07-18 Thread Gonzo Rock
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