October 22, 2004 at 3:45 pm
HI. I want to copy ONLY the user tables from a production database to a user database. the tables already exist so i just want to delete the old data and bring in a new copy of data. Using DTS, i have chosen the option, COPY DATA AND VIEWS FROM THE SOURCE DATABASE, but i have to manually click on the transform button to choose the option to DELETE ALL THE ROWS FIRST. If i have a couple of hundred records, this could be time consuming.
What is the best method in DTS to copy JUST data in the user tables between databases.(i don't want to copy any other objects or logins, etc)
Thanks,
Juanita
October 25, 2004 at 8:00 am
This was removed by the editor as SPAM
October 25, 2004 at 10:40 am
In DTS select 'Copy Object and Data' as opposed to 'COPY DATA AND VIEWS FROM THE SOURCE DATABASE' On the next screen uncheck 'Create Destination objects' and ensure "replace Existing data' is checked. If you don't want to copy all objects, then uncheck 'Select All objects' and on the next screen only select the tables'
Save and execute.
Hope this helps
Francis
October 26, 2004 at 9:32 am
Thank you. I will try that !!!
Juanita
October 27, 2004 at 6:03 am
You can try selecting the last option of copy objects and then uncheck the create objects in the next screen and select only copy data after selecting only tables.
Ranjith
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply