data import

Last Post 27 Mar 2008 10:45 AM by dbandee. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dbandee
New Member
New Member

--
27 Mar 2008 10:45 AM
Hi everyone
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?

Thanks
You are not authorized to post a reply.

Acceptable Use Policy