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 |
|
SteveM
Starting Member
1 Post |
 Posted - 2006-01-13 : 11:13:53
|
| Hi All, We have the requirement to replicate financial data to Aus from the UK, however I dont know if Replication is the best solution around?Reason why I ask this, is that to create the publication, there are in excess of 10000 articles, which takes forever and a day to create, then when setting up the push subscription, this takes equally as long.DB's physically range between 100MB and 2GB. Link to Aus is 2MB E1.The accounts server isnt the most powerful of beasts (HP DL380, 1x1.4Ghx CPU) and with 4 DB's to setup and replicate, it's going to take some time.With this in mind, I would also be looking to script out the publication should there be any failures and put it into SourceSafe, however this would also take a vast amount of time.I've thought about using Log Shipping, however I dont know if there are any better ways?Thoughts appreciated.Steve |
|
|
smcpartlin
Starting Member
1 Post |
Posted - 2006-01-16 : 13:09:32
|
| You could try using Replication Exec from Symantic. It's a veritas product that would help replication over slower links and should replicate without losing anything. You could schedule a one time job to replicate the database and then your good a gold. |
 |
|
|
|
|
|
Replicating Great Plains Data