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 |
|
saleemMSMS
Starting Member
3 Posts |
 Posted - 2010-08-16 : 00:40:05
|
hii have 2 servers. each server is running the same copy of the database and are named as the PRIMARY and SECONDARY servers.the PRIMARY server gets any data first and is stored or executed in the relevant scripts as quickly as possible. but the SECONDARY database; gets data from the PRIMARY DATABASE.there are 3 tables identified in the SECONDARY server which should be updated using the data from the corresponding tables of the PRIMARY server's relevant database. this should be done in every 15 minutes. talking about the nature of the data, there are some data rows which the values get updated. and also some rows where new records inserted as well.so what basically required is that the 3 tables of the SECONDARY server's database should get data (as either record insertions or data updates) from the relevant tables of the PRIMARY server's relevant database every 15 minutes.i cannot use replication nor install any component.anything which replication is not involved can be used !!PLEASE SUGGEST METHODS TO DO THIS FROM THE BASIC SINCE I AM NEW TO SQL SERVERthanks in advance.  |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-16 : 04:52:33
|
| create a sql agent job which has three steps to pull required data from primary to secondary tables. you need to add primary server as a linked server to secondary server for pulling data from it. then schedule job such that it executes every 15 minutes.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
syncing tabl data frm 1server 2anothr every 15mins