Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jay99
468 Posts |
 Posted - 2001-01-03 : 14:55:57
|
SQL Server 7.0 DBA Survival Guide by Mark Spenick and Orryn Sledge (Sams) states:quote:
SQL Server 7.0 can replicate to nonSQL Server ODBC or OLE DB subscribers . . . As stated earlier in this chapter, nonSQL Server ODBC sources can only be subscribers. You can use transactional and snapshot replication with all heterogeneous subscribers . . . Microsoft has opened up the interface to SQL Server replication so that ODBC or OLE DB subscribers can be publishers using third-part software . . . (page 432)
I have a table in a Paradox database on one LAN and a mirror of that table in a SQL Server database. Updates can happen at either location, and inserts and delete occur at the Paradox end only.So I guess I need to do replication via FTP and I need to set up a Merge or Immediate Updating Subscription where the subscriber is this Paradox database machine . . . so my  is, is there any 3rd party software to do this?Thanks,JayI think I am pretty much boned . . . |
|
|
|
|
|
Replication with NonSQL Server ODBC sources.