thanks...I will check it out! -----Original Message----- From: Mark Woods [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 10:08 AM To: CF-Linux Subject: Re: moving DB from MSSQL to PostgreSQL
>I am thinking about moving my MSSQL Server to PostgreSQL...does anyone know >of any good resources (links) that I can use? this looks good http://www.realsoftstudio.com/sqlporterpostgresed.php >Also, in PostgreSQL, is there a way to autoincrement ids like in MSSQL? How >can I convert my DB over with out loosing all the ids, constraints, etc? >any advice? I think you need to create a sequence and a trigger to reproduce the auto-increment feature in MSSQL, not 100% sure though. check the docs from postgresql.org Mark ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
