I need to import new records from mysql database into sql server 2K every night
so far i use DTS that truncates all tables and inserts new data
mysql db constantly grows and the task takes longer and longer
does anyone know of a better way of doing this?
Actually i only need records that are new or changed?