November 7, 2003 at 10:49 am
An employee, who travels, needs to have transferred to his machine a copy of the production data on a weekly basis. The porduction data is housed on SQL 2000 Enterprise Edition and this data is to be transferred to SQL 2000 Developer Edition. The need is to only copy changes that have been made to the data. Data will not be transferred back to the production db.
The initial transfer was completed with Import Data.
Please provide suggestions on the best method of transferring this data.
Regards,
Dave
November 10, 2003 at 8:00 am
This was removed by the editor as SPAM
November 10, 2003 at 9:57 am
I would suggest using replication. Would probably be the easiest way to do it. See BOL for more details.
You could do this with DTS but the updating of each changed value could be time consuming.
Hope this points you in the right direction.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply