Here is the complete reply with the second references link" You might consider using DTS to duplicate the Informix database to SQL2K and then use replication to maintain the data. Refer to the following links: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/infmxsql.mspx The following link refers to SQL Server 7.0 specifically but I have found it to be valid for SQL2K as well: http://www.microsoft.com/technet/prodtechnol/sql/70/evaluate/sqldifaq.mspx "Ed Bell" wrote in message news:... > You might consider using DTS to duplicate the Informix database to SQL2K > and then use replication to maintain the data. Refer to the following > links: > > http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/infmxsql.mspx > The following link refers to SQL Server 7.0 specifically but I have found > it > to be valid for SQL@K as well: > > > "Amiro" wrote in message > news:%23Bb0$VcNIHA.2308@TK2MSFTNGP05.phx.gbl... >> Hi, >> >> Our main application is running on a SCO Open Server Unix server. It's an >> Informix database. In order to free up this server a bit and because the >> application is running in text base format, we like to create a duplicate >> database on a Win2k Server running SQL 2000. Is there a way to duplicate >> the Unix Informix database on the SQL server and keep it up to date every >> night? I mean the new created SQL database doesn't need to be up to date >> like the Informix one because users who needs to connect to it don't need >> up to the minute information but archived data like sales and purchasing. >> >> So if it's possible to do that? >> >> Thanks in advance. >> >> Steve >> > >
