Post reply

copy a table from one databaseon one server to another database on another server

  • December 19, 2008 at 8:02 am

    #197620

    what i really wanted is how to copy a table from one database on a particular server to another database on a different server. i really need this urgently. i'm sure it involves some sql codes, plz help out.

    have a nice day!

  • December 19, 2008 at 8:11 am

    #915321

    If you are just looking to copy a table then backup / restore is a bit heavy. Try right clicking on the database, select Tasks, Select Import / Export Data (pick the one that makes sense - if on the database that has the data in it then select export).

    You can view help topics on this as well.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • December 19, 2008 at 8:16 am

    #915332

    Please don't repost a question that people are working on. It just leads to redundant replies and means people will waste their time answering questions that have already been answered.

    Please direct replies to - http://www.sqlservercentral.com/Forums/Topic622818-357-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 19, 2008 at 8:19 am

    #915335

    Thanks Gail. The question was phrased in a way that it appeared to be a follow-up post which made me suspicious. 🙂

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

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

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