Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Location
    UK
    Posts
    43

    Unanswered: How to copy 25 million of Rows

    Hi,

    I wanted to copy around 25 million of Rows from PROD DB to QA database. What are possible and fastest way to do the above task.


    ~Pankaj

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    fast bcp using a named pipe(mknod)

  3. #3
    Join Date
    Feb 2004
    Location
    UK
    Posts
    43

    thanks, But Looking for some other alternative

    Thanks Willy, But I was looking for some other options. As It also takes much time. Do u hv any other options.

    ~Pankaj

  4. #4
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    You can't really go faster. The alternative is to create a proxy table on one of the servers, and then do an insert ... select from ...
    But I don't think that it will be any faster - the data still has to travel from one server to the other, and has to be written to disk...

    Michael

  5. #5
    Join Date
    Feb 2004
    Location
    UK
    Posts
    43
    Michael,

    I agree with u. As already tried both the options. But both takes almost equal time to do the above task. I was wondering if some-one can provide any tool information or some other options.

    ~Pankaj

  6. #6
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    I don't understand how time taken using CIS and bcp are the same. Any faster, you will start burning the disk spindles.

    If you are on a SAN, you could just DETACH --> copy --> ATTACH(needs ASE 1252+) the database. Don't even think doing this, if this is on an NFS mount. You'll clog the mount.

  7. #7
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Maybe give them all the data in QA
    i.e. my database copy (dump and load) take 30 min in total
    Code:
    db_size  (MB)    DataSize    DataFree    LogSize     LogFree     
    ------------- ----------- ----------- ----------- ----------- 
            46000       42000    1441.277        4000    3162.590
    And it contains a large table that would take more than an hour to bcp
    Code:
    rowtotal    reserved        data            index_size      unused          
    ----------- --------------- --------------- --------------- --------------- 
    104536268   13206244 KB     11019608 KB     2076456 KB      110180 KB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •