duplicate data between database

[Guest_imported]

hello all,

I want to duplicate the data between 2 SQL 2000 database automatically(ie. when i update data in one database, the other will update corresponding table automatically). I am new in SQL2000.Anyone know how to set it in SQL2000?

Thanks,
May May

 

[sguslan]

Hi
You need to setup replication between the two servers and then publish what ever tables you need to copy.

You can do that from enterprise manager; or you can write update/delete/insert triggers into tables that need to be copied. essentially you have to insert/update/delete the same record at both tables in both databases using linked servers.

Read about replication in sql books online.

Good luck