how move data from informix, continuously

Dear Friends,
There is an "informix" dbserver, with a table that acts as cache for
continuously generated information ( an applications fills it continuously
in UNIX env).
I want to transfer(move) data from above informix table to my mssql table.
I find two way to do above movement
1- write an application that selects some info from Informix and insert
records to destination mssql then delete source records based on last
identity field
2- use schedule "Import Data" to copy data, simple but can't delete copied
data upto moved records not newer records
is there any other method? can I improve 2nd method to delete copied record
also?
thanks for any suggestions
TarvirdiHi Tarvirdi,
I need a wee bit more info to suggest something. What is the version of
Informix you are using, also you refer to a cache table, can you be more
specific? Hopefully you are not trying to examine/manipulate the internal
logging tables which control Informix data cahing and replication - chances
are you will break them.
Also some food for thought. Even when one undertakes continuous replication
from one informix instance to another, the drain on resources is quite
significant and also forces checkpointing to occur at the end of every commi
t
work statement. Typically one wouldn't attempt to do continuous replication
unless the application was so crucial that automatic and immediate failover
was required - which isn't possible with SQLServer anyway and arguably not a
great idea in Informix (don't the users want to know that something has just
gobe crach-bang?).
Gice me some more info and I'll try and help.
"Tarvirdi" wrote:

> Dear Friends,
> There is an "informix" dbserver, with a table that acts as cache for
> continuously generated information ( an applications fills it continuously
> in UNIX env).
> I want to transfer(move) data from above informix table to my mssql table.
> I find two way to do above movement
> 1- write an application that selects some info from Informix and insert
> records to destination mssql then delete source records based on last
> identity field
> 2- use schedule "Import Data" to copy data, simple but can't delete copie
d
> data upto moved records not newer records
> is there any other method? can I improve 2nd method to delete copied recor
d
> also?
> thanks for any suggestions
> Tarvirdi
>
>