Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Question with OLTP and DSS applications at the same time

Status
Not open for further replies.
pengzhang

pengzhang

Technical User
Oct 19, 2002
22
CA
Hi Guys,

Currenly we have an environment which needs both OLTP and DSS applications at the same time. I tried to build two databases to server for them. And I was using load/unload timely replicate data from realtime database to statistic database. Since the two databases were on the same box.For performance, I'm thinking to move statistic database to another box. I'm wondering besides load/unload, are there some tools like DTS in SQL2000 to replicate data between servers? I don't want use High Availability Replication since it's continuous log-based replication and I just want a batch copy during off-peak time.

Thanks
 
Status
Not open for further replies.

Similar threads

jamescpp
  • Locked
  • Question
listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port
Replies
0
Views
200
jamescpp
jamescpp
kray4660
  • Locked
  • Question
Stored Procedure attempt
Replies
0
Views
156
kray4660
kray4660
KaronW
  • Locked
  • Question
Do multiple "case" lines run against each line or is each run against the table ?
Replies
0
Views
140
KaronW
KaronW
evgeniosc
  • Locked
  • Question
Copy rows as they inserted on a replica table using trigger
Replies
0
Views
151
evgeniosc
evgeniosc
omkhan
  • Locked
  • Question
accoring thread404-451532 the solution is given in this link http://www-01.ibm.com/support/docview.w
Replies
1
Views
120
PHV
PHV

Part and Inventory Search

Sponsor

Back
Top