Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    sheffield, uk
    Posts
    14

    Unanswered: Transferring databases between servers

    I need some advice on copying databases, stored procedures, views, logins ..etc from a SQL Serevr 7.0 server, to a new SQL Server 2000 server.
    Is it better to backup the databases on one server and then restore them to the other. Or id it easier to use the Wizards to Import everything from new server, or to Export everything from the old server ?

    Any advice would be appreciated. I need to ensure that I do not miss anything, in particular Stored Procedures in the old master database.
    Mark Davies
    itsmarkdavies@hotmail.com

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Stored procedures in master is a bad idea I would move them into a user database as soon as possible.

    You can find all the SPs as they will be user rather than system objects and script them off.

    Backup and restore (or detach/attach) is safest method - and gives you a copy of what you have done. I wouldn't do this for system databases though.

Posting Permissions

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