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 |
|
sindy
Starting Member
1 Post |
 Posted - 2010-01-27 : 01:14:58
|
| Hello everybody,We have a requirement of replicating selected tables from the master database (DB1) to a secondary database (DB2). Both databases reside on different locations. DB2 will have its own tables, which refer to the primary key of the replicated tables e.g. product id will come from DB1 and DB2 adds further details e.g. product price in that region. The replication happens once daily to get the periodic updates.When the data becomes old OR not in use, it will be deleted from DB2, where as all the data remains in DB1. This is to reduce space usage on DB2. A specific requirement is, when the next replication occurs, it should not repopulate the deleted data in DB2. Any idea how to achieve this using SQL server.Thanks in advance |
|
|
ServerTeam
Yak Posting Veteran
83 Posts |
Posted - 2010-01-27 : 09:01:50
|
| Dont re-initialize replication this in daily runThanks,ServerTeam |
 |
|
|
|
|
|
SQL replication with one time synchronization