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