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 |
|
beyonder422
Posting Yak Master
124 Posts |
 Posted - 2007-07-17 : 15:27:11
|
| Is it possible to have a replicated table that you can open from and input data manually?That is, I've got a table that I am replicating data to and I want to add some manual data to this table, every now and then.Will this break replication?www.beyonder422.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-17 : 15:30:28
|
| It will not break transactional replication if you add data to the subscriber. I'm not sure about merge replication.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
beyonder422
Posting Yak Master
124 Posts |
Posted - 2007-07-17 : 16:28:53
|
| that's exactly what I needed to know.Thanx...www.beyonder422.com |
|
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2007-08-15 : 16:02:08
|
| It could break replication. Let's say you have a table with 10 records, Primary Key values 1 - 10 at the publisher & subscriber, then you manually add record 11 at the subscriber. Now, if record 11 gets added at the publisher, replication is going to send it to the subscriber as an INSERT, but will find that it's already there, and your job will fail. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-03 : 17:07:00
|
| not really your best option, why not create a new table and just create a view to link the two together? Unless you want the changes made in the subscriber go back to the publisher to update it... merge is what you are looking forHTH--------------------keeping it simple... |
|
|
|
|
|
|
Manually input data into replicated table