Transferring datanase users between legacy & new system
Posted on 2007-08-08
Hi, I need copy the existsing users & roles from one server to another due toackup a server uprade. Curently all the databases etc have been transferred (I don't know if via backup / restore or other) but the users & roles have not been sent across.
The two servers old & new can see each others'nstances on network so I should be able to transact sql script from the legacy to the new yes?
How best to achieve the transfer / copy of these tables and is there any other tables apart from users and roles I need consider ?