Drop all your constraints, then re-add them after Importing your data. >>> [EMAIL PROTECTED] 06/28/05 4:10 pm >>> Taco,
Not that simple, I have tried to use the DTS method and never can get it to work. I have multiple tables that have constraints and relationships that DTS seems to not be working with, maybe it's the way I am trying it. I just can't seem to copy the data over using DTS, I'll put it down to me not understanding DTS properly I guess. Any thoughts. Regards Andrew Scott Analyst Programmer CMS Transport Systems Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9699 7988 - Fax: 03 9699 7976 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Tuesday, 28 June 2005 3:46 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Strange request for a SQL tool DTS, just export the data into the other database, you can specify in the options what you want to transfer and whether you want to insert into the identity field. Just right click the table in question, click export and follow the prompts.. > Does anyone know of a tool (free preferably) that will copy data from one > database to another (SQL 2000) without taking the Identity (auto) key with > it. > > > > I have 2 databases that I need to migrate to one, and the data is identical > apart from the Identity field. Any tool that could allow me to select which > fields (columns) to copy would be good. If I didn't have some many damn > tables, I would write this myself but due to a time constraint I thought I > would pop a question to you guys as someone must have come across something > like this before. > > > > I do have red gate, but can't figure out if I can do this with that tool, > and DTS keeps failing for some reason. > > > > Any thoughts or ideas are welcome. > > > > > > Regards > Andrew Scott > Analyst Programmer > > CMS Transport Systems > Level 2/33 Bank Street > South Melbourne, Victoria, 3205 > > Phone: 03 9699 7988 - Fax: 03 9699 7976 > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ ________________________________ Taco Fleur - E-commerce Development Manager Shelco Searches & Services An Authorised ASIC Information Broker www.shelco.com.au Ph: + 61 7 3236 2605 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
