I testing the DTS tool on SQL Server 2000 on a test server.
My company deals with conveyor system and most of our database tables contains information about our conveyors. If something on a conveyor changes we have someone that updates that information using access. How do I append the data to the actuall database without over writing the real database. I would like all good information to stay the same and only add whats new.
So far I've created a temp database lets call it dbName_Temp. I've imported the tables from access into the temp DB. Now how to I had the new or any diffrent information without creating dups or changing the good database?