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/
