Post reply

copy tables with indexes

  • May 17, 2005 at 9:07 am

    #60138

    Hi all, I like to copy a large table(14 million records) along with it indexes from database A to database B.  What is a better approach?  Thanks in advance!

  • May 18, 2005 at 1:29 am

    #559489

    The better approach is to provide a bit more information

    What servers are you running? Are the databases on the same server? How much data is in each row?

    The more details along these lines the better.

     

    --------------------
    Colt 45 - the original point and click interface

  • May 18, 2005 at 5:24 am

    #559529

    I am running on SQL Server 2000.  Thy are both residing on the same server.  Record or row length is 2510 bytes.  Thanks! 

  • May 18, 2005 at 12:33 pm

    #559688

    Bulk-copy into new tables (no indexes), and then create the indexes following.

    Regards, Melissa

  • May 18, 2005 at 1:03 pm

    #559690

    Any way to copy table along with indexes?  Thanks!

  • May 18, 2005 at 1:05 pm

    #559691

    Create table with index, then bcp (export/import); however, the bcp process will take *much* longer.

    It is more efficient to create the tables afterwards.

    Regards, Melissa

  • May 18, 2005 at 1:17 pm

    #559695

    Thanks!  I'll give that a try.

  • May 18, 2005 at 1:21 pm

    #559697

    Did you mean create the indexes afterwards?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply