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 |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2002-05-16 : 08:43:51
|
| Hi, I have db on Server A, which has to be replicated on Server B(only five tables).A dummy db is created on Server B.Server B has the production db also. The dummy db has been created to map two columns b/w the dummy db and production database on server B for one of the tables. Using Transactional replication,same status is being b/w the db on Server A and dummy db on Server B. I am thinking of updating the data b/w dummy db and production db on server B using an update trigger for the table where in the columns have to be mapped, how can we do it???????Using the trigger, the updation has be checked for all the columns and then updated according for the particular rows. Is there any better solution , for the complete process??Sql Server 2000 is used.Thanx in advance:)))))) |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-05-16 : 09:11:11
|
| Yes, an update trigger can perform dml against another database on the same server.Aside from that nugget, I don't understand what you are trying to do enuff to suggest a better method.<O> |
 |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-05-16 : 11:24:57
|
| I think you might have to be a little more clear on this one... I've done alot of work with replications and triggers. Triggers aren't the best thing to be using, they put alot of strain on servers if there used on tables that get updated too much. If you explain what your doing here a little better maybe we can come up with a few other solutions.Y'know... call me out of the loop.. but wtf does b/w mean?and is updation a word? |
|
|
|
KHeon
Posting Yak Master
135 Posts |
Posted - 2002-05-16 : 12:20:35
|
| Me too, no idea what b/w stands for (except for black/white but that doens't fit here).Kyle HeonPixelMEDIA, Inc.Senior Application Programmer, MCPkheon@pixelmedia.com |
|
|
|
purisqlserver
Yak Posting Veteran
73 Posts |
Posted - 2002-05-17 : 00:28:39
|
| Let me explain in detail again. There are five tables in db(1) on Server A. These five tables have to be replicated on to the production db(2) on Server B. I am thinking of Transactional replication to do this,but only for four of the tables. One of the tables is replicated on to db(dummy) on Server B. This is done,so that the columns could be mapped between the table in dbdummy and db2 on server B. so,how can we use a update trigger to update data between db(dummy) and db2 on Server B????????? Hope,its very clear this time. |
|
|
|
|
|
|
|
|
Database updation-Trigger