Solved

non-SQL DB to SQL server replication through ODBC

Posted on 2007-11-21
2
250 Views
Last Modified: 2012-06-27
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?
 
   
0
Comment
Question by:pureandco
2 Comments
 
LVL 28

Expert Comment

by:Bill Bach
ID: 20332426
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.
0
 
LVL 23

Accepted Solution

by:
Racim BOUDJAKDJI earned 125 total points
ID: 20336633
<<Is there a possibility to set-up transactional or merge replication using ODBC channel only?>>
Use linked servers (you may select several provider there)...

Hope this helps...
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now