View Poll Results: For Migration process How many persantage using SSIS or Normal Backup/Restore

Voters
2. You may not vote on this poll
  • SSIS

    0 0%
  • Backup/Restore

    2 100.00%
  • DTS

    0 0%
Results 1 to 2 of 2

Thread: MS Sql 2000 to 2005 Migration using SSIS HOW?

  1. #1
    Join Date
    Apr 2009
    Posts
    1

    Unhappy MS Sql 2000 to 2005 Migration using SSIS HOW?

    We have two new servers setup with Windows 2003 and SQL 2005. They are to replace 2 older servers running Windows 2000 and SQL 2000. Both these servers communicate to each other and have a number of applications and reports that will need to be reconfigured on the new servers.


    Database management, ODBC connections, programming, reporting, stored procedures….. with minimal down time.

    What is the best Precausion (Disaster Recover plan) should i have to followup?

    What is the method should i have to taken inorder to smooth migration bt the server?

    What is the tools should i have use either SSIS or normal Backup and restore?

    If it is SSIS would some one guide me pls?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    >>What is the best Precausion (Disaster Recover plan) should i have to followup?

    Keep good backup of all dbs.

    >>What is the method should i have to taken inorder to smooth migration bt the server?

    backup/restore user dbs, can sql logins and jobs with ssis.

    >>What is the tools should i have use either SSIS or normal Backup and restore?

    ssms to backup/restore, bids for ssis.

Posting Permissions

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