Thanks, that is very helpful. I am moving to postgreSQL because of the stability of linux vs. windows, and you can't beat the price!
I am also looking at clustering or mirroring the postgreSQL servers for redundancy. Anyone had any luck with this? --Josh -----Original Message----- From: Brian Panulla [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 12:00 PM To: CF-Linux Subject: Re: moving DB from MSSQL to PostgreSQL At 09:34 AM 6/27/2002 -0600, you wrote: >Forgive me for being a linux/postgresql newbie! No problem... we were all there at one point. :) >Also, in PostgreSQL, is there a way to autoincrement ids like in MSSQL? Not exactly like in MSSQL, but better. :) You need to use a Sequence to generate the next id for a column. View the Flash tutorial on Sequences from postgresql.org to get started: http://techdocs.postgresql.org/college/001_sequences/ Sequences behave differently than do the autonumber columns in MySQL or Access and the Identity attributes in SQL Server, and thus require special care when converting columns. But once you've used sequences, the other db types are annoying. :) No more CFTRANSACTIONs or the SELECT MAX(*) trick required to set up foreign key relationships. >How can I convert my DB over with out loosing all the ids, constraints, etc? >any advice? If you have a complicated SQL Server database, you'll probably want to re-engineer it manually, unless you have an advanced ER tool like ERWin or Sybase PowerDesigner that can properly reverse engineer a complex database. What I've done is to generate an SQL script from SQL Server via Enterprise Manager and convert the script by hand to Postgres's syntax and peculiarities. It can take a long time, but I don't trust any of the reverse engineering tools I have at my disposal to do anything more than map a DB. Once I have the DB schema built, I use Enterprise Manager's DTS to move the data from the SQL DB to the Postgres DB .... works great. Good luck with PostgreSQL... it's rapidly becoming my favorite DBMS... SQL Server's still holding that title, but barely. Brian _____ Brian Panulla [EMAIL PROTECTED] Chief Information Officer 814.238.6680 Elmwood Media Group www.elmwoodmedia.com ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ 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.
