Post reply

How can I transfer table?

  • May 20, 2009 at 10:53 pm

    #209890

    hello,

    I need to port one table from one server to another. Does sql server have way to save a table as tab delimited/comma separated file? Is there a better way transport data?

    Thank you in advance.

  • May 20, 2009 at 11:01 pm

    #998075

    You can script it out......and run the script in the other server........

    And always u can use import and export wizard.........

    Tanx 😀

  • May 21, 2009 at 3:01 am

    #998121

    BCP is a great tool for this.

  • May 21, 2009 at 7:59 am

    #998275

    If it's a one-off, I'd go with the import/export wizard. If this is something you'll need to repeat down the road, you might consider writing code (i.e. SP) to handle it.

    _____________________________________________________________________
    - Nate

    @nate_hughes

  • May 21, 2009 at 10:26 am

    #998385

    RP_DBA (5/21/2009)

    If it's a one-off, I'd go with the import/export wizard. If this is something you'll need to repeat down the road, you might consider writing code (i.e. SP) to handle it.

    ...or an SSIS package.

    Greg

  • May 21, 2009 at 11:47 am

    #998435

    Create one linked server ..then access your table and port to another


    - Pradyothana     http://www.msqlserver.com

  • May 21, 2009 at 11:55 am

    #998440

    I would say for one time purposes, Import/Export wizard

  • May 21, 2009 at 11:36 pm

    #998681

    Not (only) to marketing myself, but if you have PowerShell at hand, check http://getmssqldump.codeplex.com in terms of data movement. With this, you can extract the records into insert commands. It might help you.

    -- Erik http://blog.rollback.hu

  • May 25, 2009 at 7:29 am

    #999657

    use a select script to generate an insert script for each row in the table and coupled with a create table script you have your table in portable format

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • May 26, 2009 at 2:11 am

    #999743

    hi

    there are lot more ways to transfer table from one instance to another instance.

    1.import and export

    2. run script on source instance, copy and excute the same script on other instance

    3.bcp

    4. snapshot

    5.SSIS

    etc

    Goodluck

    KingManjunath

Viewing 10 posts - 1 through 9 (of 9 total)

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