Post reply

Copy table options...

  • October 23, 2009 at 10:11 am

    #227416

    We are trying to determine the best process for copying a subset of tables from database to another. So far, I have changed the destination db to bulk-logged recovery model to reduce transaction logging. The code was originally written as select * into..which I am trying to get away from. I think my best option may be to use bcp to export the tables and then use BULK INSERT to import the data.

    Once I do this and have all the tables set up, is there a way to just append the new rows to the tables? This would be done on a daily basis. It seems like a waste of resources to export and import the tables every day. I would like to be efficient as possible with low impact on performance.

    Thanks in advance! 🙂

  • October 23, 2009 at 10:23 am

    #1070153

    replication would do this.

    If you have some type of date or timestamp field that can determine what's "new", you can build an SSIS package to easily move these.

  • October 23, 2009 at 8:34 pm

    #1070330

    schep021 (10/23/2009)

    The code was originally written as select * into..which I am trying to get away from.

    Why are you trying to get away from such a simple, effective, and useful tool?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 2 (of 2 total)

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