mibuso.com
Home› SQL General
Options

Export Users from SQL Server to Another

roshandilrukroshandilruk Member Posts: 51
edited 2007-05-17 in SQL General
Hi All,

Is it possible to export all the user from one SQL server and import to another. I'm installing a new database for my client and I need to take the same users from the pervious server.

Is this possible ??

Thanx

Comments

  • Options
    DenSterDenSter Member Posts: 8,304
    If you're running windows authentication, I think all you need to do is run a full synchronization and that will take care of everything.
    Daniel Rimmelzwaan
    RIS Plus, LLC
    MVP - Business Apps
  • Options
    kinekine Member Posts: 12,562
    In case you are using DB users and you have SQL 2005, you can use special component for user transfer in Integration services. Else you need to find or create some script for that and this will be not so easy.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    thaugthaug Member Posts: 106
    Easy. Look here:
    http://support.microsoft.com/kb/246133
    There is no data, only bool!
  • Options
    krikikriki Member, Moderator Posts: 9,090
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Sign In or Register to comment.