|
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 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/ |
