can I (how) have a snapshot that pulls from an odbc source
From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 12/16/04
- Next message: Hassan: "changing recovery model to databases : replication"
- Previous message: Fany Vargas [MSFT]: "Re: call sp_MSmakegeneration (?)"
- In reply to: john_at_intelsat: "can I (how) have a snapshot that pulls from an odbc source"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 16 Dec 2004 08:20:21 -0800
Have a look in BOL at publishing to heterogenous
subscribers. If the DSN is created at the distributor, it
should appear when you enable the subscriber (right click
on the replication monitor, distributor properties,
subscribers, new, odbc data source...).
Alternatively, you could achieve the same aim using DTS
or linked servers from within SQL Server.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
- Next message: Hassan: "changing recovery model to databases : replication"
- Previous message: Fany Vargas [MSFT]: "Re: call sp_MSmakegeneration (?)"
- In reply to: john_at_intelsat: "can I (how) have a snapshot that pulls from an odbc source"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
