June 9, 2011 at 8:46 pm
I the following points to be clarified on Replication process.
My criteria is based on following points and the replication should be a 2 way.
1. Source and Destination Tables are different Name
2. Source and Destination Filed names are different
3. Source and Destination field type different ... not all the time...need to check source field type is bit and destination field type is tinnyInt
4. Check how insert, update and delete will work
5. How do we setup the replication when databases are on different servers and replication on different server
Ex: DB1 on Server 1, DB2 on server 2 and Replication on Server3
Need to check how do we setup the credentials etc ......
June 9, 2011 at 10:18 pm
asritha_v (6/9/2011)
1. Source and Destination Tables are different Name2. Source and Destination Filed names are different
I don't think Replication works if table and field names are different.
May be use have to create your own solution using SSIS.
June 10, 2011 at 1:46 am
You will be able to replicate to different object names. Columns I've never done before and dont believe its possible (I can't find documentation for it)
You could replicate to a table of the same name to keep things simple and create a number of (nonreplicated) views on the subscriber to overlay the individual tables with no performance impact.
You've got 3 options for 2 way replication.
1. Merge (preferred)
2. Transactional with updateable subscriptions
3. Peer to Peer transactional.
June 10, 2011 at 12:24 pm
My creteria is 2 way replication and I have around 10 tables in both the databases to be replicated. Please explain how we can achieve i am new to SSIS.
June 10, 2011 at 8:42 pm
For different source and destination table names you'll want to look at @destination_table parameter for sp_addarticle.
For different source and destination schemas you'll want to create an indexed view on the publisher which looks like the subscription object. The same goes for different source and destination field types.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply