Is it possible to move table to different DB without changing connection strings?

  • Sorry, meant to post in SQL 2008...

    Would it be possible to move a table to a new database, but still reference it on the old name?

    We backup & restore a database on different environments alot and I would like to move one of the tables out of the backup as to save space. The table is currently 25Gb.

  • No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1353492-391-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

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

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