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 |
|
rajesha
Starting Member
36 Posts |
 Posted - 2002-10-31 : 04:17:22
|
| i have a table A1 in a database DB and am replicating that table to table A2 in same database in another server.i want to replicate table A1 to one more table A3 in which i want only records which are changed (updated ur inserted)daily .if there is no change in the record of A1 i dont want that record to come in A3.here A1,A2,A3 have same table structure.is it possible through replication.can anybody tell me? |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-10-31 : 10:07:11
|
| Which server/database is table A3 on ?Which version of SQL Server are you using ??I'm not sure replication can quite handle this sort of scenario, you may be better off using DTS or bcp. Where is the server with table A3 on ? Is it in another country ?===========Paul |
 |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-10-31 : 13:14:45
|
| Transactional replication can be setup for this. You can create a publication of this table with various filters to break it into a2 or a3 or whatever other table you want. Couple restrictions in the sever type your have, edition/licensing of sql server, and that sort. Your tables will need an auto incrementing ID for some options. Look it up in bol for further info-----------------------SQL isn't just a hobby, It's an addiction |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-10-31 : 13:22:41
|
| Transactional replication is meant for this purpose only!--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
|
|
|
replication of changed data only?