May 9, 2008 at 12:26 am
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 for replication.
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
May 9, 2008 at 12:30 am
Hi
Take a full backup of database1 and restore in database2. and use Transaction Replication.(real time) for both the database in sync. When ever the inserte, delete, update happens it will replicate immediately.
May 9, 2008 at 12:54 am
Thanks Jay,
Sorry,but Restore will done only if the both the schema's are same mean table names ,field names and data types - length etc..
but here not that case..here both are different schema's and different tables names. how can i restore..
thanks
May 9, 2008 at 2:51 am
Hello you can do replicate for the same table name and same data types which exisits in both the databases or servers.....
For example :
If you have table A in a Database1 and Same structure of table in Database 2.... with same data types also..
One thing you can do... copy the strucure of all table that u want in database2 and do transaction replication for those tables....
if u want additional info... read this...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply