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 - 2005-10-31 : 18:54:09
|
| Chris S writes "I have a sales database on one SQL Server that is going to query off from numerous tables on an accounting database that resides on another SQL Server. When a end user modifies a table on the accounting database I want the sales database to get the update in their queries. If this creates too much overhead I would like the accounting database to update the sales database every 30 minutes. I heard this can be done without using replication so what do you suggest? Triggers?" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-10-31 : 19:39:42
|
depends on how soon do you need changes to synchronize.i'd go with replication.Go with the flow & have fun! Else fight the flow  |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-10-31 : 20:30:57
|
| The accounting database should have history detail if it's a decent accounting system. You could just run a job that captures data between x and y times ever 30 minutes. There are a lot of possibilities to this answer. How many records are you talking about? What does the design of the two systems look like? Are there any conversions between the two systems? etc, etc, etcMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Updating between SQL Servers