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 |
|
SuperGhost
Starting Member
12 Posts |
 Posted - 2008-11-05 : 12:28:04
|
| My team has been asked to move our application to its own SQL Server. We currently run on SQL 2000 and our app can move to any SQL version 2000 or above, including 2008.One of the issues is that we rely on information from at least 2 separate databases on the SQL 2000 server. We need to write to a few tables in each of the databases infrequently but we do need to see updates immediately.What options do I have to implement a new SQL Server that will fit into my scenario described above?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-05 : 12:32:48
|
| Seems like what you need is Transactional Replication. Read about transactional replication in books online. |
 |
|
|
Elisabeth Redei
Starting Member
15 Posts |
Posted - 2008-11-05 : 14:43:55
|
| Hi,You can use Distributed Queries between separate SQL Server instances (on the same server) or between different servers. Books Online contains an overviewy section which is a good starting point (this happens to be from BoL 2005 but it's applicable from 7.0 and onwards): "Distributed Queries", http://technet.microsoft.com/en-us/library/ms188721(SQL.90).aspx.HTH!/Elisabeth |
|
|
|
|
|
|
Sharing data between SQL Servers