Timeseries data migration

Discussion in 'Trading Software' started by sset, Apr 4, 2012.

  1. sset

    sset

    Hello,

    We have a requirement for timeseries database migration from FAME to timeseries database of Sybase RAP. Sybase RAP may require SAS analytics on top. We have below queries.

    (a) Each vendor store timeseries data in its own optimized way. No open standards exists. What is the best way, practices for timeseries data migration?

    (b) Can timeseries migration performed by ETL?

    (c) Kindly send any documentation, links for reference in the areas of timeseries data migration?

    (d) What are the best ways of optimizations, performance for timeseries data?

    (e) How do we migrate from sqlserver timeseries data to Sybase RAP?

    Thanks
     
  2. bidwhiz

    bidwhiz

    I am interested in doing the same thing except using SQl Server 2008 R2. I am guessing the solution must be very similar. Have you received any feedback?