I am a SQL Server DBA with minimal Informix 11 experience.
I'm tasked with extracting an entire Informix database (circa 8GB according to systables in Informix) into a SQL Server database. I plan to do this using linked server use OPENQUERY.
However I am worried about the impact this may have. It's not a large database at all and I know Informix does row level locking (was worried it may do full table locking) and I'm going to run it when the application is not busy.
Does anyone have any advice regarding this?