Thread: PostgreSQL to MSDE conversion help
I have a PostgreSQL database running under linux. Unfortunately the company has deemed it neccessary to move from Linux to Windows, so now I am tasked with moving all of the PostgreSQL database tables and stored procedures over to MSDE. The data itself can easily be recreated. The main problem is porting the structure of the existing DB over. I've never done this before, and don't have any ideas where to even start. Has anyone got any pointers or help? Thanks, John
>I have a PostgreSQL database running under linux. Unfortunately the >company has deemed it neccessary to move from Linux to Windows, so now >I am tasked with moving all of the PostgreSQL database tables and >stored procedures over to MSDE. The data itself can easily be >recreated. The main problem is porting the structure of the existing >DB over. > >I've never done this before, and don't have any ideas where to even >start. Has anyone got any pointers or help? > > Is PostgreSQL on Windows not an option? It currently works with sygwin and a native Windows version is being worked on. Look in http://techdocs.postgresql.org/guides for more info. Kaarel