pureandco
asked on
non-SQL DB to SQL server replication through ODBC
Is there a possibility to set-up transactional or merge replication using ODBC channel only?
We need to replicate one of the old databases we can't really create publication on. However, we do have ODBC driver for it which works well when creating linked tables in Access.
If SQL Server can't do it - is there any 3rd party replication agent that works with ODBC connections?
We need to replicate one of the old databases we can't really create publication on. However, we do have ODBC driver for it which works well when creating linked tables in Access.
If SQL Server can't do it - is there any 3rd party replication agent that works with ODBC connections?
I would recommend looking at any of the class of Extract/Transform/Load (ETL) applications. One good place to start is Pervasive Software's Data Integrator product, which has built-in connectors for over a hundred data sources and targets.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.