Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Use replication or DTS for MS/SQL Server and ODBC linked table?

Posted on 2007-03-21
3
Medium Priority
?
317 Views
Last Modified: 2013-11-30
I have a linked server on an MS/SQL Server from a remote ODBC datasource. What I'd like to do is replicate changes from the linked table to a physical database within SQL Server. This should also delete items that were deleted on the ODBC datasource. Is this something that can be handled natively (via replication or DTS), or do I have to get a 3rd party software to monitor this?
0
Comment
Question by:bemara57
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 16

Expert Comment

by:rboyd56
ID: 18766671
What is the ODBC datasource that you are linking to?
0
 

Author Comment

by:bemara57
ID: 18766709
It is an AcuServerODBC (Acucorp). I have the client driver installed on this SQL machine, so I can open the table and view it's contents.
0
 
LVL 8

Accepted Solution

by:
san_spy earned 2000 total points
ID: 18766758
I think you need to go for some third party solution since  replication or DTS will not drop the objects with in the sql server. Both are to replicate the data changes. You cant even make a schema change in the replicated tables. Try using the DDL triggers and DTS package combination or else 3rd party would be better.
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

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…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

618 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