The only thing I'd add is that SQL Server 7.0 will have an enhanced facility to move data between platforms. I haven't had a chance to look at it yet, but it sounds pretty nice. Of course, 7.0 probably won't ship for another 6 months or more, so it's not really an option yet.

>There is a better way to do this. There are direct "any platform" to "any platform" replicators available where I could go directly from Informix to SQLServer, we can't afford them yet. If you want to look at the specs on one, run a search on "OmniReplicator".
>
>Josh may be able to add more advice, sounds like he's been there also.
>
>Good luck.