Post reply

Help: Transform Task -vs- Copy SQL Server Objs Task?

  • September 10, 2007 at 2:01 pm

    #69175

    I have to copy data from a db on one server to a matching schema on another server.

    What are your thoughts on the best way to do this?

    It seems like it would be very simple to use the

    Copy SQL Server Objects Task,

    un-check "Create destination objects"

    ensure that "Copy Data" is selected.

    click on Objects, and select the tables I want to copy data from.

    Am I missing something? Should I use a Transform Task?

  • September 10, 2007 at 3:04 pm

    #732619

    I prefer to do a SQL task to delete the existing data (if that fits your needs), then do a transform task. That may be just because that is what I see most places and I'm used to it. I think it's probably just a matter of preference.

  • September 10, 2007 at 4:15 pm

    #732624

    • disable all constraints on tables depending on the destination table.
    • delete the destination table.
    • copy SQL object: keep existing table, copy data, append data instead of replace.
    • re-enable all constraints on tables depending on the destination table.

    This is why I HATE SQL 2005 Server Management Studio.  I don't have to do this much of work when I do samething with SQL 2000.

  • September 10, 2007 at 10:13 pm

    #732666

    Thanks for reminding me. I am of course, working w/ sql server 2000.

     

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

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