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.
