Results 1 to 2 of 2

Thread: Data Archiving

  1. #1
    Join Date
    Dec 2003
    Location
    Bangalore
    Posts
    28

    Unanswered: Data Archiving

    Hi ,

    I need to archive my production database to a new Server.....

    Is it possible to move data using INSERT INTO ServerName.DBName.dbo.TableName from the current Database Server!!!

    Do I need to create a linked server to do this....or shoud I go for DTS..

    Thanks
    Cheriyan.

  2. #2
    Join Date
    Apr 2004
    Posts
    9
    You have too many options :
    1.- Backup and restore in the new server.
    2.- Create a linked server and generate a script to the all the insert..into your other tables.
    3.- Use DTS.

    If this is a one-time move, because a hardware upgrade, not a task that should be somewhat performed periodically, then take option 1.

    Reagrds,

Posting Permissions

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