Go into Enterprise Manager, pull down on Tools to Data Transformation Services and select import or export. Go through the wizard. You may have to set up DNS etc to get to the other database. You will also need to play around with the mappings etc. within the wizard. You probably won't nail it first shot. At the end of the wizard save it in case you need to go back and tweak it. A visual version of the DTS will be available under Data Transformation Services local packages.
Lee -----Original Message----- From: Russ [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 12:07 PM To: CF-Talk Subject: RE: MS SQL 2000 I believe SQL has an import utility that does just that. > -----Original Message----- > From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 15, 2006 12:55 PM > To: CF-Talk > Subject: OT: MS SQL 2000 > > Does anyone know of a good util (or if it can be done in SQL 2000 as i > can't see how) to import data from one database into another and allowing > fields to be mapped? (Something free would be good!) > > Thanks, Jenny > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.405 / Virus Database: 268.10.10/418 - Release Date: > 14/08/2006 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
