How to mirror tables between 2 mssql 2005 databases on 2 diffrent servers?

How do i mirror a few tables in one database to another database on another server? Is it possible or do i have to do some kind of sync between them?
gobbalobbaAsked:
Who is Participating?
 
RiteshShahConnect With a Mentor Commented:
mirroring will make mirror of full database, if you need table based solution than I would suggest replication. If you like to see more about creating replication than do have a look at below URLs

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-configuring-replication.html

http://www.informit.com/articles/article.aspx?p=601350

http://www.mssqltips.com/tip.asp?tip=1451
0
 
RiteshShahCommented:
Do you want mirroring for tables? not for complete database? if that is the case than you should go for replication.
0
 
gobbalobbaAuthor Commented:
yes between tables. How do i set up replication?
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
gobbalobbaAuthor Commented:
nice!
Ill follollow the guides and probobly will get it goin. One question thou, is it sharing thrtough a smb share so that i need to open in the fw between them for smb? or is it purely sql port that is needed?
0
 
RiteshShahCommented:
SQL port will do.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
If you want to keep two tables in two different databases to be in sync, then the simplest way is to have triggers for INSERT, UPDATE and DELETE statements in the Main Server to have it reflected in the Destination Server.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.