Merge users from one database to another

Discussion in 'Databases' started by ASTRAPI, Sep 16, 2009.

0
  1. #1
    Hello

    How can i merge from one database to another the users?

    Usernames - Passwords - Emails

    ?

    Thank you
     
    ASTRAPI, Sep 16, 2009 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    with queries
     
    crivion, Sep 17, 2009 IP
  3. ASTRAPI

    ASTRAPI Guest

    Messages:
    500
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yes but how?
     
    ASTRAPI, Sep 17, 2009 IP
  4. EpicServices

    EpicServices Peon

    Messages:
    111
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    1. Run the following statement.

    ALTER DATABASE database_name SET OFFLINE

    2. Move the file or files to the new location.

    3. For each file moved, run the following statement.

    ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name, FILENAME = 'new_path\os_file_name' )

    4. Run the following statement.

    ALTER DATABASE database_name SET ONLINE

    5. Verify the file change by running the following query.

    SELECT name, physical_name AS CurrentLocation, state_desc
    FROM sys.master_files
    WHERE database_id = DB_ID(N'<database_name>');
     
    EpicServices, Sep 22, 2009 IP
  5. secrethq1

    secrethq1 Peon

    Messages:
    21
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    what he said ^^
     
    secrethq1, Sep 25, 2009 IP