Hi every body,
I need some valuable suggestions from you.
Here I have entirely two different databases. I need to communicate both the databases in real-time manner. My questions are…
1. First i need to dump all the existing data from database1 to database2, which is having no relevant fields in it and it’s located at other server – How?
2. Second thing if any insertions, updations and deletions occur in table1 in database1 immediately effect in table2 in database2 Bi-Directional. – How?
Here both servers having SQLServer2000-sp2.
Here database1 having 350 tables and database2 having 100 tables, but I need only 20 to 30 tables.
There are some solutions I found in web.
1. DTS package
2. Transactional Replication
3. Writing triggers
Please suggest me which is suitable to above criteria.
Thanks in Advance