July 27, 2005 at 11:14 pm
Hi
I want to back and restore only required tables from a one SQl server to other .
Can u pls hel p me how this can be done .
regards
venki
August 1, 2005 at 8:00 am
This was removed by the editor as SPAM
August 5, 2005 at 1:54 pm
I use 'BCP' to copy data from tables on one server to another server. I use BCP 'out' from the source tables (for each table). For the destination server, I truncate the tables, run BCP 'in' and then run 'DBREINDEX' to rebuild the indexes after the data has been loaded. Books Online should help with syntax for BCP. Hope this helps.
August 10, 2005 at 10:56 am
Couldn't you also use Integration Services (DTS) to do a transfer of data, including the indexes for the exact tables that you want? You could also carry over permissions. You can even set this up as a job.
I do this all the time to get a mirror image of a particular table at a particular moment in time. You can even rename the table to meet specific criteria.
cd
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply