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 |
|
sourvil
Starting Member
14 Posts |
 Posted - 2008-12-02 : 11:38:51
|
| Hi all,I want to merge replicate 2 tables by using SQL Server 2005 Replication Tool. And all of them have 4 columns. Everything works fine when i replicate all columns.But additionally, in another case i want to replicate only 3 columns. And when i try to do this, the 4th column in Subscription Database will be dropped automatically. How can avoid this?Regards. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-02 : 12:50:09
|
| That is obvious when you apply filter. |
 |
|
|
sourvil
Starting Member
14 Posts |
Posted - 2008-12-02 : 14:23:52
|
| So, no solution for this scenario? |
|
|
|
sourvil
Starting Member
14 Posts |
Posted - 2008-12-04 : 02:21:17
|
| no help? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-04 : 08:48:25
|
| Your question is not clear? Can you elaborate? What did you apply in filter? |
|
|
|
sourvil
Starting Member
14 Posts |
Posted - 2008-12-04 : 11:56:52
|
| Ok, i will explain again. Let's guess something like this:Database1 (Publisher)Table1 --> Column1, Column2, Column3Database2 (Subscriber)Table2 --> Column1, Column2, Column3In SQL Server 2005 Merge Replication,I want to Replicate only Column1 and Column2 from Database1 to Database2. But when i try this, it will transfer (Replicate) values from Table1 to Table2. And it drops Column3 in Table2.I tried to set value "Keep existing object unchanged" for the property "Action if name is in use". But it gives an error like: ------------------------------------------------------------------------------------------------------------------------------------------------------------------"Command attempted:{call sp_MSsetconflicttable (N'tblMembers', N'MSmerge_conflict_BPub_tblMembers', N'BDO', N'B1', N'BPub')}Error messages:Incorrect syntax near 'ID'. (Source: MSSQLServer, Error number: 102)Get help: http://help/102The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)Get help: http://help/MSSQL_REPL-2147201001"------------------------------------------------------------------------------------------------------------------------------------------------------------------Thanks for reply. Regards. |
|
|
|
|
|
|
|
|
Column Filter