It's the upsizing wizard. Works well for basic info but in the past I've seen problems when people have yes/no fields in access. (ie: it used to turn yes/no into a bit then the bit couldn't be null. But that was SQL6.5...) And you may want to go in and change the field types as it often will make everything a nvarchar vs varchar With this tool make sure that import/keep or however it's worded indexes checkbox is marked.
-----Original Message----- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 3:03 PM To: CF-Talk 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. ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
