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 |
|
ssunny
Posting Yak Master
133 Posts |
 Posted - 2009-06-11 : 11:42:42
|
| Let’s say I have a database A with 50 tables. And suppose I created a new database B with same 50 tables with data as A. And from now onwards I want to sync the data from A to B for all 50 tables.Meaning any insert, update or delete on any table in database A should replicate in database B. I want this process to run every 30 mins which will check in database A for any table which has an update,insert or delete and sync the database B with the same. I am using sql 2000. What is the best approach I can use here? I thought of creating a insert,update and delete trigger on all tables but dont know how efficient that would be! Can I use DTS for this?Please suggest.Thanks. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-11 : 12:09:38
|
You have used the word replicate in your post.Think replication is the solution.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
ssunny
Posting Yak Master
133 Posts |
Posted - 2009-06-11 : 12:12:46
|
| Thanks for the reply but how efficient the replication would be if I have to do it 20 times a day!! |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-11 : 12:16:14
|
A replication can do also each 10 minutes or so.It is efficient.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
ssunny
Posting Yak Master
133 Posts |
Posted - 2009-06-11 : 12:23:43
|
| Wow thanks. I did not know about it as I never used replication. so which replication should I use? And can I force it to run if any table in database A has an update,insert or delete?Thanks again. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-11 : 12:43:22
|
quote:
Originally posted by ssunny
Wow thanks. I did not know about it as I never used replication. so which replication should I use? And can I force it to run if any table in database A has an update,insert or delete?Thanks again.
i think what you need is transactional replication. see belowhttp://www.informit.com/articles/article.aspx?p=599700 |
|
|
|
ssunny
Posting Yak Master
133 Posts |
Posted - 2009-06-11 : 12:58:13
|
| Thanks Visakh I am looking into it. Will let you know if I have any problems. Thanks again |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-11 : 13:17:18
|
no worries...you're welcome  |
|
|
|
|
|
|
sync the data from database A to B