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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-11 : 08:11:53
|
| Mark writes "Hi, we have 5 msde db's at remote locations with dialup or dsl vpn. How do we update a central ms-sql server with any data changes? Thanks" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-12-11 : 18:19:12
|
| Replication (is the short answer).Books online is a great start, take a look there.Damian |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2003-12-11 : 21:20:39
|
| How big are the databases? Number of tables/columns Size of the actual filesDo the databases have a good design? Normalized?How big of time window and how often do you need to update the central DB?Do you need to also update the small DBs on a schedule with everything in the central DB?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
combining ms-sql database