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
