Great, but what happens when you wish to change the name of a field in a
lookup table?
Do you run update statements on EVERY foreign key field?
Wouldn't it be easier to just change a value in the database?
Further, requesting that user's supply indeces isn't the best way to work;
user's have a tendancy to want to change the value of their indices from
time to time. For example, If I have table a:
CustomerID int
AccountingID char
CompanyName char
And I want to change the accounting ID (for whatever reason), I'd be okay.
However, if I were to omit the customerID field and stick with the
Accounting ID Field, the change would be acceptable.
Further, joins on integer fields work much faster than joins on character
fields. The database has that much less to work with matching up.
You are right though, autonumber fields can be a real pain. What you should
usually do in a migration from access to sql server is first go into all of
your tables, turn off autonumber, and leave the field as an integer field,
when you upsize, go back in and revert to autonumber.
-----Original Message-----
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 11:27 AM
To: CF-Talk
Subject: RE: SQL VS ACCESS
I've learned to avoid using autonumber fields whenever possible. It makes
the job of moving databases between platforms simple. At worst, I have to
put the primary key constraints back on the index fields of each table -
which is no big deal.
---mark
------------------------------------
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric ====================================
> -----Original Message-----
> From: Bud [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 4:02 AM
> To: CF-Talk
> Subject: RE: SQL VS ACCESS
>
>
> On 6/12/01, Norman Elton penned:
> >Make sure all your fields that should be indexed are indexed. I think
> >the upsizing wizard forgets about this.
>
> The upsizing wizard does a pretty good job of rebuilding the indexes
> and relationships. It's DTS that loses that stuff.
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
