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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS detect changes

Status
Not open for further replies.
jagdeep

jagdeep

IS-IT--Management
Jul 29, 2002
12
IN
I need to create a DTS to sync data on my test server from production server. cant set replication as these two servers dont ping each other. however i can ping them both.

is there any thing in SQL - with which i can detect what rows have changed. and scheduule my DTS to run after 5 minutes.
Thanks in advance for suggestions..
-singhDBA kafe@rediffmail.com

Regards - Singh
 
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
Get Min and Max Time until it changes - Please Help 1
Replies
7
Views
217
bborissov
bborissov
Cpreston
  • Locked
  • Question
Coding Issue changes required 1
Replies
4
Views
177
dhookom
dhookom
DougP
  • Locked
  • Question
SSMS 2014 bug not freshing to see new changes made to tables or otherwise
Replies
2
Views
164
philhege
philhege
wbodger
  • Locked
  • Question
Copying DDL and DML changes 2008 R2
Replies
7
Views
213
wbodger
wbodger
WMXTeam
  • Locked
  • Question
Convert DTS package to .Net
Replies
0
Views
175
WMXTeam
WMXTeam

Part and Inventory Search

Sponsor

Back
Top