How to trigger a auto update - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How to trigger a auto update

Author

Topic

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2008-11-18 : 06:53:45

Dear Friend,

My situation as follows

i have two databases , each databases are in different location for example one is in Washingten and another one is in california.each databse have two tables.

washingten databse("DB1") have table called ("Emp","Status")
california databse("DB2") have table called("employee","Status")

so my need is when ever any updates done in "Status" table of washingten database that should be automatically upadted in "Status" table of california database also.

how this logic could be achieved? do i need to use trigger and procedure for this ? is there any examples for this please provide me so that i can understand please

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-18 : 06:56:04

Seems like what you need is to set up transactional replication between dbs. Read about transactional replication in books online.

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2008-11-18 : 07:12:06

please give me some detailed description for this logic please

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-18 : 07:17:01

http://www.databasejournal.com/features/mssql/article.php/1438201/Setting-Up-Transactional-Replication-A-Step-by-step-Guide.htm

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2008-11-18 : 22:33:28

Thank you visakh16

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2008-11-18 : 22:41:21

Dear visakh16,

one more doubt should i use only windows NTServer or can i use xp? because the tutorial which u have shown intimates windowsNTserver. so please give me sugestion

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-18 : 22:49:09

quote:
Originally posted by sqllover

Dear visakh16,

one more doubt should i use only windows NTServer or can i use xp? because the tutorial which u have shown intimates windowsNTserver. so please give me sugestion

are you trying to implement replication in your local system?
In ideal case, your server where sql server is used should be having a server class os.

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2008-11-19 : 00:00:02

hi visakh16 ,

actually now i am going to try this logic in my LAN environmet. i have 10 systems in my LAN. each system OS is XP.so i have installed sqlserver2005 in both machines. after sucess of the LAN i will go for WAN Environment. please guide me

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-11-19 : 01:26:22

Yes....
you can implement this on Xp also......

Arnav
Even you learn 1%, Learn it with 100% confidence.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources