Results 1 to 4 of 4

Thread: Migrate users

  1. #1
    Join Date
    Apr 2002
    Location
    Enschede, Netherlands
    Posts
    1

    Smile Unanswered: Migrate users

    Does anyone knows if it's possible to migrate users to another server? I use windows 2000 server and SQL server 2000, Integrated windows sequrity.

    I want to use the second server as "Standby" Server. On the first server there are already created many windows-accounts. Do I have to create all theat users again on the other server? and all roles and permissions?

  2. #2
    Join Date
    Feb 2002
    Posts
    14
    You can script the users and permissions by selecting the SCRIPT DATABASE USERS AND DATABASE ROLES and the SCRIPT OBJECT LEVEL PERMISSIONS from the Options Tab in the Scripting dialog boxes from within Enterprise manager.

    After the scripts are created, you can edit them to remove everything except the Permission statements.

    Now you can execute the script anytime you need to re-create the rolls and permissions.

  3. #3
    Join Date
    May 2002
    Posts
    95
    can these scripts be run on another machine??

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Any SQL script can be run on any SQL Server. The real question is probably should it be run. There should be no harm, if the script does not drop tables/procedures/views, or delete data. You should review the script to make sure you understand what it is doing.

Posting Permissions

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