copying tables to another box

Results 1 to 2 of 2

Thread: copying tables to another box

  1. #1
    Yusup Guest

    Default copying tables to another box

    I just got a new box with sql server load in it. My old computer also has sql server where all my databases and tables is located at.<BR>My question, is there an easy way to &#039;migrate&#039; or copy my databases and tables (with their primary key and also data) from my old computer to my new box?<BR>any help is greatly appreciated.<BR><BR>thanks<BR><BR>Yusup

  2. #2
    Jeremy_D Guest

    Default RE: copying tables to another box

    Use DTS. Select the option "Transfer SQL Server Objects". In contradiction to the "Transfer Tables" option this will transfer all (selected) objects including indexes, constraints, data, etc, even permissions if you want to.<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts