| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-05-18 : 05:15:03
|
| what's the best way to synchronize to mssql databases(one is 2005 express and one 2005) |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-18 : 12:27:55
|
| What? Post your question clearly so you get answer. |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-05-18 : 13:07:35
|
| I have a mssql db on one server - I want to have an exact copy at all times on another server -- ideally i'd like if any record is inserted or changed on one it automatically gets replicated to the other - what's the best way to do this? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-18 : 14:49:40
|
| Do all tables have primary key? You can do transactional replication. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-18 : 21:26:21
|
| Two-way transactional replication doesn't work in this case, take look at merge replication. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-05-19 : 02:24:20
|
| yes all tables have primary keywhere should I look for htiswhat's the difference between transactional and merge? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-19 : 10:39:13
|
| You can find in books online. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-05-19 : 13:39:38
|
| ok so I set it up as transactional. now my question is what happens if the publication server temporarily goes down -- when it goes back up will it immediately update the subscribers?and how long does it take for the subscribers to get records added to the publication database in general?Thanks for your help. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-19 : 14:00:00
|
| Replication is handled through jobs. The log reader will startup once the agent is started. We can't answer how long it would take to update the subscriber. It would depend on how many commands it needs to replicate, how fast your hardware is, ...Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-19 : 23:19:08
|
| Keep in mind that chnages made on sql2k5 express will not be replicated to sql2k5 with transactional replication. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-05-20 : 01:42:23
|
| but if i did transactional then it just copies from the publisher to the subscriber - it's not synchronization - is that correct?also it's still going over 10 hours does that make sense - it is a big db?once it initially copies over all the records will it go much quicker? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-20 : 09:56:17
|
| you can use SQL express as a subscriber for transactional replication and do one-way synchronization If you need to synchronize both way,you need to have merge replication in place. |
|
|
|
|
synchronizing databases