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?
Do you want mirroring for tables? not for complete database? if that is the case than you should go for replication.
ASKER
yes between tables. How do i set up replication?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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.
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.