Re: Updating from Informix database
From: Mark Allison (marka_at_no.tinned.meat.mvps.org)
Date: 07/14/04
- Next message: Mark Allison: "Re: Server Name"
- Previous message: Mark Allison: "Re: MS03-031 on a cluster SQL2000."
- In reply to: CSB007: "Updating from Informix database"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 14 Jul 2004 08:24:33 +0100
CSB007,
"With Microsoft SQL Server and an OLE DB provider or ODBC driver for
Sybase or Informix, Microsoft SQL Server can send and receive database
snapshots in both directions, and send SQL Server transactions to Sybase
or Informix. For more information about implementing Transactional
replication from Sybase to SQL Server, check the Data Interoperability
Alliance Solutions page. http://www.microsoft.com/sql/partners/"
You will likely need a third party replication solution to go from
Informix to SQL Server. However SQL server transactional replication
should work just fine from SQL Server to Informix.
-- Mark Allison, SQL Server MVP http://www.markallison.co.uk Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html CSB007 wrote: > I need to continuously update a SQL Server database from the source data that is on Informix. > > What are the possible alternatives to do the job? > > If somebody have done it before, please provide inputs of how it was done? > >
- Next message: Mark Allison: "Re: Server Name"
- Previous message: Mark Allison: "Re: MS03-031 on a cluster SQL2000."
- In reply to: CSB007: "Updating from Informix database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
