Link to home
Start Free TrialLog in
Avatar of gobbalobba
gobbalobba

asked on

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?
Avatar of RiteshShah
RiteshShah
Flag of India image

Do you want mirroring for tables? not for complete database? if that is the case than you should go for replication.
Avatar of gobbalobba
gobbalobba

ASKER

yes between tables. How do i set up replication?
ASKER CERTIFIED SOLUTION
Avatar of RiteshShah
RiteshShah
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
SQL port will do.
Avatar of Raja Jegan R
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.