Its called Upsizing Wizard and its under Tools > Database Utilities > Upsizing Wizard
----- Original Message ----- From: "Ben Forta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 3:02 PM Subject: RE: Importing tables - Access to SQLServer > Dave, > > Access has a migration wizard (I forget the name) built-in that will > keep all keys and more. > > --- Ben > > > -----Original Message----- > From: Bosky, Dave [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 3:02 PM > To: CF-Talk > Subject: Importing tables - Access to SQLServer > > > Whenever I import a table into SQL-Server from MS Access I always loose > my primary keys. Is there a particular option in Enterprise Manager that > I'm overlooking that preserves primary key fields? > > Dave > > > HTC Disclaimer: The information contained in this message may be > privileged and confidential and protected from disclosure. If the reader > of this message is not the intended recipient, or an employee or agent > responsible for delivering this message to the intended recipient, you > are hereby notified that any dissemination, distribution or copying of > this communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by replying to the > message and deleting it from your computer. Thank you. > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
