[quote][b]I just want to extract user/permission from source machine and then want to run the same in my target machine through GUI way
Can I use idera for this ? if not please tell me a tool which could do this work in a GUI way.
The SSMS has rather good build-in scripting options. Just select an object, right click and select "script object as...". Also if you have defined actions (like backup or restore) in the GUI you can generate a script just before hitting the [ok] button.
To move logins and permissions in a GUI way is afaik not possible. I heard about the Idera tool by other posters. I don't have hands-on experience with this tool. I suggest you download it and try it on a test environment.
I just checked this .....looks easy to me. Please tell if there is any important selection which i may need to remember here.
also, how do I restore this backed file later on ? I see a restore menu is Microsoft Management Studio GUI.....Can I use that to restore ?
There are no 'real' important selections for backup, the link I gave you describes all options.
Restoring with the GUI is perhaps a bit less intuitive. Near the bottom of the Microsoft link you can go to the URL describing the restore process.
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **