Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
|
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 17th, 2005, 01:05 PM
Authorized User
 
Join Date: Sep 2004
Posts: 62
Thanks: 0
Thanked 1 Time in 1 Post
Default Using DTS to sync Remote Database to Local Machine

I hope someone can help. I have a SQL 2000 database that is hosted through a company which allows minimal management due to security reasons. This database is where all of my data from multiple domains is being managed. I have SQL Server 2000 also running locally and I want to synchronize my local machine with the remote as best I can. I am told that I can use DTS in order to import/export the remote into my local server. My questions and concerns are this:

1) - first off, what is the best way to set this up so that any table changes/additions are copied locally if need be. There were updates occurring on the hosted tables often so I want the local copies to be updated with records and changes just the same.

2) - How can I set this up to occur peridoically when I desire - say, 3 or 4 times per day.

I have not had to manage a remote database like this before so I want to ensure I am doing it correctly. If even a few times a day my local machine can automatically be updated with the current remote data and definitions that would be great.

I apprecaite any help in advance - thanks.

 
Old March 21st, 2005, 11:13 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

You may have several options depending on the size of your database and connections speed.

1. You can try log shipping
2. You can try also schedule a job that will
   A. backup your remote database to your local machine
   B. Restore the backup to your local Machine


Jaime E. Maccou





Similar Threads
Thread Thread Starter Forum Replies Last Post
Retore Db from a remote machine to a local machine srkvellanki BOOK: Beginning SQL 0 October 3rd, 2008 05:17 PM
Can we Sync a data in Pocket PC to local database? fukchai2000 C# 1 March 8th, 2006 10:55 AM
A Better way to sync a remote and local database? kevorkian SQL Server 2000 1 April 5th, 2005 08:09 AM
Synchronize a remote and local database - MAYBE??? kevorkian SQL Server 2000 3 March 8th, 2005 02:00 PM
WebRequest on local machine burdickdave C# 0 November 5th, 2003 07:36 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.