I want to transfer the Roles of source database to Target database .
we can import the database objects,(tables,index,trig), or a user's all objects or the whole database.
but my requirment is only the Roles from the source database to target database.How can i accomplish this job.
looking forward from anyone to reply quickly.
You should be able to extract role information from the source database's data dictionary and use dynamic SQL to replicate just the roles to the target database. I don't believe you can use a straight export/import.
Distributed Database Consulting, Inc.