I have a mySQL database that collects call detail reports, it is mySQL
becasue it runs on Linux and MSSQL is not an option. The app generating
the data only supports mySQL up to version 4, and mySQL 4 does not have
"views"

I need to get this data into a MS SQL 2000 server database in near real
time, with no more than 30 to 60 seconds latency.

Is DTS the best bet?

I guess I need to select all records from the mySQL table where the ID
(incremented unique id) is greater than the highest ID in the imported
SQL data and insert the results into the MS SQL table.

The inserts would be less than 10 or 20 per minute, simple text data.

There is a windows ODBC driver for the mySQL data source.

Am I going down the right track, or is there a better way?

thx!

Hello damon (AT) soho-systems (DOT) com,

Hmmm

DTS Can do it but for "Real Time" stuff I generally go with Replication.
DTS for me is more about a batch process. You could try this article to
see if it helps you out.

http://msdn.microsoft.com/library/de...plhet_7feb.asp



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com