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.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-09-11 : 02:47:14
|
| Dear all,i've one database in my server namely mydb1, and another database mydb2. same type of tables are there. in those tables, when ever developers are entering data, that should be automatically updated here also.i think replication suits this.daily maximum 200 transactions may occur in the mydb1.if replication suits this, which replication can i use..and please guide me for the process....and one more doubt...actually only 22 tables out 0f 1300 tabls will modify regularly... rest of those are not changed frequently...VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-11 : 02:55:58
|
The major question is "are you using sql server 2000 or sql server 2005"?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-09-11 : 02:58:50
|
| i'm using sql server 2000VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-09-11 : 05:56:46
|
| is there anyway to update only the required tables automatically?....VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-09-12 : 00:58:51
|
| why i'm not getting answere? please guide me in this regard....VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-12 : 22:32:43
|
| You can use transactional or merge replication, depends on which db to update and connection type between two servers. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-09-13 : 01:19:11
|
| it is local system to me, and both the databases are on the same systemVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-13 : 05:10:10
|
| If you don't want to use Replication you could put a Trigger on the table on mydb1 that updates the table in mydb2Kristen |
|
|
|
|
|
|
|
|
tables updation