two way replication in sqlserver 2005

Question

two way replication in sqlserver 2005

musheik

SSC Veteran

Points: 294
More actions
August 27, 2008 at 6:28 am

#191922

Hi all,
Can any body provide me guidance or scripts for two way replication in sqlserver 2005. I have done with oracle, now i need to do the same for sqlserver. I will be thankful for any body who can help me on this.
Thanks&Regards
Mujeeb

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 1

You need to learn more about how SQL Server handles replication before you would know what the equivalent is from Oracle. SQL Server has bi-directional transactional replication and merge replication. They work differently and for different purposes, depending on your needs.

http://msdn.microsoft.com/en-us/library/ms151706.aspx

http://msdn.microsoft.com/en-us/library/ms151329.aspx

musheik SSC Veteran Points: 294 More actions · Answer 2

Hi Steve,

Thanks for your intime reply. I have followed transactional replicaton of sqlserver for one way replication. which worked for me similar to oracle streams one way replication. I need similar to Oracle streams bi directional replication. Is it suitable to consider transactional replication for continuous replication?

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

Transactional is just that, replication by transaction. You can slow it down, but it works fine for continuous transactions as well.

Always a bandwidth/resource issue, but if you have enough, it performs great.

musheik SSC Veteran Points: 294 More actions · Answer 4

Thanks for clarification Steve. Another fast question for you.

I have set up sqlserver one way replication completely through UI only as per steps mentioned in msdn. In Oracle, I setup replication completely using scripts.Is it possible for setting up replication in Sqlserver using Scripts, as in Oracle ? If possible can you provide any links for the same if available with you or else some insight into that.

Thanks&Regards

Mujeeb

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 5

Anything you can do from the UI can be done through T-SQL. One easy way to see what you need to do for this is to go into Management Studio, right-click on the replication you already set up and generate the scripts.

MSSQL Replication and Oracle Replication are pretty different. I would suggest you start by reading the entire books online section on replication before you go much further. Don't assume anything works the same - most things do not.

musheik SSC Veteran Points: 294 More actions · Answer 6

Thank you, I follow your suggestions and inputs and hope you don't mind if I ping you in case if I struck.:)

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 7

No problem.

I would suggest you start a new thread if you have additional specific questions.