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 |
|
chenthorn
Starting Member
6 Posts |
 Posted - 2004-11-10 : 15:03:16
|
| Hello! I am just beginning with transactional replication, and I have a publisher with a primary key on the identity column (UID), some data, then an adddate (varchar 8) column with CCYYMMDD data in it. I want to replicate this table to a server based on the adddate value (all records pushed since a given adddate). My replication attempts seem to only want to work off of the primary key column. How do I get it to work off of the adddate column, or do I even really want to? Thank you for any help in advance The publisher (and subscriber) tables look like this: create table temp ( uid bigint, data_1 varchar(20), adddate varchar(8) ) |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-11 : 01:04:20
|
| transactional replication will push whatever changes made on the publishing database.unless...you change the default sp's that does this for you. go to the publication properties>articles>click on one article>commands--------------------keeping it simple... |
 |
|
|
|
|
|
Help with Transactional replication