Improve company productivity with a Business Account.Sign Up

x
?
Solved

non-SQL DB to SQL server replication through ODBC

Posted on 2007-11-21
2
Medium Priority
?
263 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 29

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 375 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

607 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