Post reply

copy tables between databases on same yukon server

  • July 14, 2005 at 3:45 am

    #66683

    hiya,

    I'm using yukon and whidbey.I simply want copy a table (contents and all) between different databases on the same machine..I looked into

    script tables as --> copy to

    But this doesn't seem to be it.I can't copy and paste via:

    1) sql management studio

    2) or whidbey IDE

    Can anyone suggest the best way to do this?

    cheers,

    yogi

  • July 15, 2005 at 1:00 am

    #574681

    Try:

    SELECT * INTO NewTable FROM existingdb.dbo.existingtable;

  • July 15, 2005 at 3:03 am

    #574701

    cheers,

    I always have to fight the urge to do this thru the gui

    yogi

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

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