You can also disable check constraints with DTS (I believe). If not, then you just need to make sure you run the export in the right order, i.e. the tables with the foreign relationships first. example;
Person User Email First insert the Person because the User table relies on a record being present in the Person table etc. etc. > 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 leave-cfaussie- [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 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/
